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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8190GSchubert Jackie E Jr · Jamestown, TNS/N E-2658 N8191KSummerfields Animal Hospital Pllc · Fort Worth, TXBuilt 1991 · S/N E-2662 N8191RM B Duncan Inc · Bakersfield, CABuilt 1974 · S/N D-9675 N8192RStarr Aviation LLC · Birmingham, ALBuilt 1974 · S/N E-598 N8194RHouse Of J Inc · Lake Charles, LABuilt 1974 · S/N TC-1763 N8195JJani-King Int'L Inc · Addison, TXBuilt 1993 · S/N E-2789 N8196RSchwab Robert · Austin, TXBuilt 1974 · S/N TE-1002 N8198BOrmont Michael L Trustee · Poughkeepsie, NYBuilt 1991 · S/N CE-1637 N8198MGokul LLC · Landrum, SCBuilt 1993 · S/N E-2787 N8198TBuilding Swell LLC · New York, NYBuilt 1993 · S/N CE-1723 N819BRooney William T · Lakin, KSBuilt 1978 · S/N D-10186 N819BABig Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-866 N819DKBankston David P · Horseshoe Bay, TXBuilt 1983 · S/N EA-387 N819DMPottier Michael John · Dover, NHS/N EA-456 N819LAMukherjee Jason S Trustee · Simi Valley, CABuilt 1994 · S/N E-2869 N819LBBowles Jeffrey D · Fitchburg, WIBuilt 1977 · S/N E-1126 N819MCHagar Corporation · Fort Lauderdale, FLBuilt 1968 · S/N TE-600 N819MMPremier Aero LLC · Gonzales, LABuilt 1981 · S/N TC-2401 N819T3rd Gen Aviation LLC · Lisbon, NDBuilt 1973 · S/N D-9507 N81ABAcceler8 Aviation LLC · Livermore, CABuilt 1969 · S/N TC1247 N81AGDuke Transportation LLC · Idaho Falls, IDFirst renewal noticeBuilt 1973 · S/N P-219 N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12 N81BBDunigan Patrick J · Jackson, MIBuilt 1973 · S/N CE-449 N81BEBeagles & Elliott Enterprises LLC · Mansfield, TXS/N P-474 N81DLLewis Donald C · Winters, CABuilt 1977 · S/N E-1156 N81FGBrandis Robert DBA · Taylorville, ILS/N E-2424 N81HBMinard Patricia J · Cheney, KSBuilt 1981 · S/N E-1902 N81JBWeinstein Berthold W · Livermore, CABuilt 1968 · S/N D-8748 N81KTTalhelm Kenneth K · Muncie, INBuilt 1956 · S/N D-4652 N81RJHughes Frank H · Hackberry, LABuilt 1979 · S/N E-1617 N81SHSharff Steven T · Georgetown, DEBuilt 1978 · S/N M-2095 N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147 N81VBNeal Foster Trucking Inc · Merrill, ORBuilt 1980 · S/N D-10315 N81VTDouble D Aircraft LLC · Sergeant Bluff, IABuilt 1974 · S/N D-9640 N81WMPaladin Aircraft Restoration Inc · Monticello, UTBuilt 1977 · S/N CE-739 N81WRGreen Donald · Batesville, TXBuilt 1981 · S/N TE-1192 N8200DAyers Aviation LLC · Archer City, TXBuilt 1957 · S/N D-5293 N8201DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1957 · S/N D-5288 N8201ETigre Air LLC · Missoula, MTBuilt 1993 · S/N E-2777 N8202DHot Start Aviation LLC · Chapin, SCBuilt 1957 · S/N D-5325 N8204DMunck Ernest C · Prosser, WABuilt 1957 · S/N D-5296 N8204MBlue Sky Flying Club LLC · Granger, IABuilt 1991 · S/N E-2667 N8206DParagon Grain Inc · Chester, MTBuilt 1957 · S/N D-5306 N8209ARocky Top Real Estate Investments LLC · Paola, KSBuilt 1993 · S/N E-2781 N8209DZukowski Hawkin · Madison, WIBuilt 1957 · S/N D-5298 N820BRSkywood Aviation LLC · Wayne, NJBuilt 1996 · S/N E-3011 N820GHMcdavitt Edward T · Sugar Land, TXBuilt 1994 · S/N E-2870 N820MAMccomas John C · Granbury, TXBuilt 1964 · S/N TC-833 N820RRettig & Associates LLC · Bessemer, ALBuilt 1959 · S/N D-6046 N820VNovember 820v LLC · Fitchburg, WIBuilt 1995 · S/N E-2947

Back to AD 99-05-13 R1 WD