Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124 N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440 N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276 N455RHanusin Mark J · Huntley, ILBuilt 1967 · S/N D-8526 N455RBGh Enterprises Inc · Baton Rouge, LABuilt 1977 · S/N TE-1099 N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405 N455TBSmith Loren D · Great Falls, MTS/N 310R1860 N455XTreat-Yo-Self Confections Inc · Corona, CABuilt 1973 · S/N 310Q1007 N4560KRegistered aircraftBuilt 1948 · S/N NAV-4-1560 N4560MPhillips William S · Normandy Park, WAFirst renewal noticeBuilt 1978 · S/N CE-770 N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052 N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069 N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237 N4563SMeyerhoff Scott G Trustee · Reno, NVBuilt 1975 · S/N CE-604 N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736 N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182 N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804 N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549 N4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeBuilt 1975 · S/N CE-605 N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745 N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252 N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717 N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298 N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676 N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525 N456DMHnw Aviation LLC · Melbourne, ARBuilt 1978 · S/N E-1378 N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896 N456HWestwind Inc · Marina, CABuilt 1951 · S/N NAV-4-2228-B N456JMLandmark Aviation Services LLC · Sarasota, FLBuilt 1974 · S/N 340-0535 N456KPNorthern Arizona Renal Aviation LLC · Flagstaff, AZBuilt 1991 · S/N CE-1597 N456KWQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N TJ-427 N456PSGaston Trevino Jr · Brownsville, TXBuilt 2004 · S/N 29-0335 N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314 N456STMcbride Ken · San Martin, CABuilt 1975 · S/N 414-0810 N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625 N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766 N456WWJandal Group Holdings LLC · Winters, TXBuilt 1981 · S/N TJ-390 N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220 N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150 N4572FRichards Stewart G · North Palm Beach, FLBuilt 1966 · S/N 185-1079 N4572LFiegel Donald H · Ward, ARBuilt 1968 · S/N 421-0172 N4572SQualley Patrick Dion · Brooklyn Park, MNBuilt 1975 · S/N E-744 N4573FNapflin Erich P · Wasilla, AKBuilt 1966 · S/N 185-1080 N4574FKlingenmeyer Korey L · Anchorage, AKBuilt 1966 · S/N 185-1081 N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118 N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222 N4577LLucas John · Norco, CABuilt 1972 · S/N 340-0115 N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553 N4579FWagner Jan W · Lopez Island, WAS/N 185-1086 N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479

Back to AD 86-13-04 R3