Registered aircraft · 13,521

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.

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72 N1000JEagle Mountain Aviation Inc · Owasso, OKBuilt 1966 · S/N M-1000 N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000 N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980 N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163 N100ANWatson Family Investments LLC · Houston, TXBuilt 1977 · S/N D-10084 N100DRWolfe Stephen Charles · Tulsa, OKBuilt 1976 · S/N TK-2 N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158 N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729 N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100HPHinds Community College · Raymond, MSBuilt 1980 · S/N TK-116 N100HSAir Works Ltd · Wilmington, DES/N E-3506 N100KJDrewyor Kenneth · Eaton Rapids, MIBuilt 1977 · S/N D-9987 N100KWBaldassarre Thomas Anthony · Gillette, NJBuilt 1980 · S/N D-10336 N100LKKoebele Thomas R · Cape May, NJBuilt 1977 · S/N CE-686 N100MRCarlson Carl J II · Aledo, TXBuilt 1973 · S/N TC-1512 N100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767 N100NNDunnair LLC · Panama City, FLBuilt 1973 · S/N D-9465 N100PRKinder Eric Eugene Trustee · Tucson, AZBuilt 1970 · S/N D-9167 N100PSG & C Property Hc LLC · San Francisco, CABuilt 1987 · S/N CE1140 N100RABonanza Holdings Group LLC · Greenville, NCBuilt 1977 · S/N P405 N100RBIngraham Donald S · New Bern, NCBuilt 1991 · S/N CE-1586 N100RESchooler Jordan Benjamin · Hummelstown, PABuilt 1981 · S/N CE-987 N100RFN100rf Ghost LLC · Burleson, TXS/N MB580 N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211 N100SPWright Richard S · Half Moon Bay, CABuilt 1970 · S/N D-9107T N100TOwyhee Pacific LLC · Kalispell, MTBuilt 1960 · S/N TD-350 N100TXJones Joseph Clayton · Bossier City, LABuilt 1976 · S/N D-9854 N100WSQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1202 N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249 N100XPHeath Darrell L · Houston, TXBuilt 1991 · S/N CE-1564 N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4 N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922 N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428 N1014WAnderson Timothy R · Wilmette, ILBuilt 1973 · S/N TE-906 N1015WStanton Thomas Michael · Mcallen, TXBuilt 1973 · S/N TE-907 N1016WMichael Deem Crow · Pilot Point, TXBuilt 1973 · S/N D-9478 N1018WLampe Ryan · Leonardtown, MDBuilt 1973 · S/N D-9449 N101AXFogg Britt · Springdale, ARS/N P427 N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076 N101BMTurk Mike · Pinehurst, TXBuilt 1971 · S/N TE-847 N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146 N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417 N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722 N101JMSale Reported · Clay Center, KSSale reportedBuilt 1967 · S/N D-8459 N101KGQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N EA392 N101KMHolliday Dean M Trustee · Klamath Falls, ORBuilt 1985 · S/N E-2253 N101PAKeenan Mark · Chico, CABuilt 1979 · S/N EA-39 N101WEBadgerland Aero LLC · Las Vegas, NVBuilt 1971 · S/N D-9231

Back to AD 99-05-13 R1 WD