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.

N532GMsd Sales Inc · Cedar Rapids, IABuilt 1977 · S/N E-1038 N532JTSowards David · Savannah, GABuilt 2004 · S/N 0834 N53315Denton Aerial Spraying · Las Animas, COBuilt 1975 · S/N 18802213T N53368Arnt Aerial Spraying Inc · Worthington, MNBuilt 1974 · S/N 18801790 N5336CMiller Aviation LLC · Huntington, INBuilt 1978 · S/N 310R1542 N5336YBlue Sky Inc · Lone Rock, IAS/N 21064170 N5337CMarc Inc · Bolton, MSBuilt 1978 · S/N 310R1543 N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171 N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376 N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871 N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T N533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103 N533C71sq Inc · Wilmington, DEBuilt 1978 · S/N CJ135 N533CDAvem LLC · Salt Lake City, UTBuilt 2004 · S/N 0995 N533CFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1479 N533HTWest Wings LLC · Blair, NEBuilt 2004 · S/N 1046 N533KAKamaka Air LLC · Honolulu, HIBuilt 1973 · S/N 20700216 N533PMMccollom Perry C · Saint Louis, MOBuilt 2009 · S/N TH-2255 N533SZilz Tammy S · Saint Peters, MOBuilt 1965 · S/N D-8028 N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034 N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328 N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421 N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675 N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N5343SRayham LLC · Oxford, GABuilt 1980 · S/N R18201549 N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419 N5347WAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1955 · S/N G275 N5348MLooney Tunes Air LLC · Omaha, NEBuilt 2004 · S/N 0792 N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874 N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176 N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416 N534CDAdvanced Tree Care Inc · Lincolnshire, ILBuilt 2005 · S/N 1623 N534DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1955 · S/N G-750 N534EGilday Aviation LLC · West Harrison, INS/N D-7825 N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109 N53511Didia Robert · Fraser, MIBuilt 2004 · S/N 0864 N53512Rapp Steven B · Hawthorne, CABuilt 2004 · S/N 0868 N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877 N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388 N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170 N535CCrystal John · Las Vegas, NVBuilt 1998 · S/N 29-0146 N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244 N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345 N535PTaylor Jim A · Kernersville, NCBuilt 1966 · S/N D-8119 N535PGSs Aviation LLC · Westlake, LABuilt 2005 · S/N 1293 N535QGeaux Fly LLC · Bossier City, LABuilt 1968 · S/N TE-609 N535RFlight Training Pro LLC · Nashville, TNBuilt 2005 · S/N 29-0381 N535RTN535rt LLC · Provo, UTS/N 0407 N535SCardoza Real Estate Inc · Eagle, IDBuilt 2001 · S/N 0014 N535SBSpeedy Bonanza LLC · Waitsfield, VTBuilt 1964 · S/N D7485

Back to AD 86-13-04 R3