Skip to content

Registered aircraft · 3,959

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:87-21-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1') 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:87-21-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
  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:87-21-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
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.

N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N1247GNafziger Aviation Leasing LLC · Wittman, MDBuilt 1974 · S/N 310Q1098 N124DPBaja Air LLC · Wilmington, DEBuilt 1979 · S/N 310R1670 N124DRLeventis Phil P · Sumter, SCBuilt 1973 · S/N 340-0219 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898 N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484 N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809 N1258GConroy Bruce M · Martinez, CABuilt 1974 · S/N 310Q1109 N125CPLinscott Jeffrey R · Boring, ORBuilt 1972 · S/N 340-0093 N125DMCallegari Gino A · Susanville, CABuilt 1966 · S/N 310K0176 N1267GChesnut James Scott · Oak Point, TXBuilt 1974 · S/N 310Q1118 N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909 N126TMFlynfish Air LLC · Rome, GAS/N 310R1231 N1271GSee Christopher · Owenton, KYS/N 310Q1122 N1274GSol Aerial Surveys LLC · Las Vegas, NVBuilt 1974 · S/N 310R0001 N1276GCarter Joseph C · Brookline, NHBuilt 1974 · S/N 310Q1126 N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231 N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808 N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N12CRTrudnak Michael W · Mansfield Center, CTBuilt 1977 · S/N 421C0279 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130 N12MKIndus Health Inc · Santa Clara, CAS/N 421C0421 N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014 N12RJDesert Air Ambulance Inc · Blythe, CABuilt 1977 · S/N 421C0306 N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911 N12TTThoms Robert D · Clyde, MIS/N 310H0066 N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171 N12WTMtzb Corp · New York, NYBuilt 1974 · S/N 421B0829 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322 N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022

Back to AD 87-21-02 R1