OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N729BCNeedy LLC · Maud, OKBuilt 1973 · S/N P-254N729CWWright Matthew J · Bowling Green, OHBuilt 1987 · S/N E-2390N729MWpp Nautical LLC · Waller, TXBuilt 1960 · S/N BA-517N729TJurskis Chester · Dallas, TXBuilt 1964 · S/N D-7690N72ALQuigley Partick M · Slidell, LABuilt 1968 · S/N TE-584N72AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 1977 · S/N E-1093N72BGRegistration Pending · Farmingdale, NYRegistration pendingBuilt 1981 · S/N TE-1198N72BRPrestige Air Travel · Middletown, DES/N E-2065N72CGGarvin Carroll E · Scottsdale, AZBuilt 1980 · S/N TJ-264N72CUKuhlke K Lee · Englewood, COBuilt 2001 · S/N EA-673N72KKBluebird Holdings LLC · Morris, MNFirst renewal noticeS/N E-3521N72LRSchnell Michael L · Spearman, TXBuilt 2001 · S/N EA-676N72MBSwenson Chuck · Stanchfield, MNBuilt 1977 · S/N E-1010N72MDBenanti Philip E · Melville, NYFirst renewal noticeBuilt 1977 · S/N E-1149N72MFSilverdart Inc · Wilmington, DEBuilt 1984 · S/N E-2191N72PVBowman Theodore R · Santa Ynez, CABuilt 1988 · S/N E-2452N72SCLsa Aircraft Holdings LLC · Houston, TXBuilt 1984 · S/N TJ-477N72TMTango Sierra LLC · Mountain Brk, ALBuilt 1976 · S/N TC-2005N72WACrosby Seth J · Anchorage, AKS/N WA-72N72WPRegistered aircraftBuilt 1985 · S/N E-2288N72WTRoberts Gregory · Bethesda, MDBuilt 1984 · S/N E-2165N7300UZimmerman Kyle A · Philadelphia, PABuilt 1953 · S/N D-3449N7301BFowler Kenneth R · Cleveland, ALBuilt 1954 · S/N D-3765N7302BDangberg Dennis · Wayne, NES/N D-3763N7303BRegistration Pending · Enterprise, ALRegistration pendingS/N D-3766N7305BDennerline Jeff · Fairview, ORS/N D-3768N7307BWatkins Todd Michael · Midland, TXBuilt 1954 · S/N D-3770N730SMStockmans Inc · Visalia, CAS/N D-10009N7310BDaniels Alfred K · League City, TXBuilt 1955 · S/N D-4166N7311BB A M N Air Inc · Naples, FLS/N D-4202N7312BKomishock Matthew A · Conyngham, PABuilt 1954 · S/N D-3775N7313BPena Edwin A · Mission Hills, CAS/N D-3776N7314BKuskie Donald D · Littleton, COBuilt 1954 · S/N D-3777N7315BKomon Antonio · Apple Valley, CABuilt 1954 · S/N D-3778N7315RMitchell Michael · Prattville, ALBuilt 1974 · S/N E-558N7316BVolkl Joseph E · Ava, MOBuilt 1954 · S/N D-3779N7318BGonzales Gabriel J · The Dalles, ORBuilt 1954 · S/N D-3781N7319RLima 5 Aviation LLC · Horse Shoe, NCBuilt 1974 · S/N TC-1706N731DMartilla Robert W · Washougal, WABuilt 1951 · S/N D-3001N731DFFrisbee Dennis R · Denton, TXBuilt 1963 · S/N D-7267N731EMAuer William W · Saint Petersburg, FLBuilt 1988 · S/N E-2446N731GVSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N EA-631N731MLRomine George · Sahuarita, AZS/N D-10208N731RTWarndahl John · Kyle, TXBuilt 1968 · S/N M-1172N731SSale Reported · Phoenix, AZSale reported, canceledBuilt 1968 · S/N TE-541N731SKBoaz Casey L · Osage Beach, MOBuilt 1963 · S/N TC-515N731WCCross Wayne Trustee · Novato, CABuilt 2001 · S/N E-3404N7320BHoover Frank J · Upland, CAS/N D-3783N7322BRamon Benjamin · Yuma, AZBuilt 1954 · S/N D-3785N7329BFilkins Joseph M · Norco, CABuilt 1954 · S/N D-3792
Back to AD 99-05-13 R1 WD