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.

N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440N455MArnold Curtis L II · Corsicana, TXBuilt 1965 · S/N TC-975N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276N455QSouthern Utah University · Cedar City, UTBuilt 1972 · S/N TC-1441N455RHanusin Mark J · Huntley, ILBuilt 1967 · S/N D-8526N455RBGh Enterprises Inc · Baton Rouge, LABuilt 1977 · S/N TE-1099N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N4560MPhillips William S · Normandy Park, WAFirst renewal noticeBuilt 1978 · S/N CE-770N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237N4563DFitzgerald Robert D · Geneva, NYBuilt 1956 · S/N D-4718N4563SMeyerhoff Scott G Trustee · Reno, NVBuilt 1975 · S/N CE-604N4565DNiolet Rene J · Long Beach, MSBuilt 1956 · S/N D-4743N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736N4566DPetersen Mark E · Onawa, IABuilt 1956 · S/N D-4739N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804N4567DWillis Bernie W · Wasilla, AKBuilt 1956 · S/N D-4729N4567MCassinelli Steven W · Sacramento, CABuilt 1978 · S/N P-467N4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeBuilt 1975 · S/N CE-605N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745N456ADStafford Arthur · Oak Bluffs, MABuilt 1996 · S/N E-3026N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252N456CAntique Air Holdings Inc · Wilmington, DEBuilt 1956 · S/N D-4529N456DLGt Aviation LLC · Mountain Home, ARBuilt 1972 · S/N TC-1461N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378N456KPNorthern Arizona Renal Aviation LLC · Flagstaff, AZBuilt 1991 · S/N CE-1597N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390N4570DEspolt Steven R · Kingfisher, OKBuilt 1956 · S/N D-4735N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150N4572DSchiffmacher Richard T · Glendale, AZBuilt 1956 · S/N D-4761N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744N4574DBates James L Jr · Slidell, LABuilt 1956 · S/N D-4757N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118N4574NStearman Aviation Inc · Crawford, COBuilt 1944 · S/N 6727N4576DDjm LLC · Ogallala, NEBuilt 1956 · S/N D-4755N4577DTeed Brad S · Vancouver, WAS/N D-4728N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807N457MSNesk Aviation LLC · Orlando, FLBuilt 1979 · S/N E-1523N4581DPutnam George · Anchorage, AKBuilt 1956 · S/N D-4762N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808N4583DWalkowicz Eddie F Jr · Garland, TXBuilt 1956 · S/N D-4738N4584DZeller Steven · Alpharetta, GABuilt 1956 · S/N D-4746N4584SAd Astra Aviation LLC · Shawnee, KSBuilt 1975 · S/N E-751N4585DAmen Nelson P · San Antonio, TXBuilt 1956 · S/N D-4752N4585MCorman Bruce D · Burlington, COBuilt 1978 · S/N E-1239N4585SValiair Limited Company Trustee · Casper, WYBuilt 1975 · S/N E-752
Back to AD 99-05-13 R1 WD