Registered aircraft · 2,630

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

N1000EWr Hess Co · Oklahoma City, OKBuilt 2002 · S/N 550-1011 N100ACSmith Vicars & Co LLC · Charlottesville, VABuilt 2002 · S/N 5546 N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170 N100DSCascade Peaks Aviation LLC · Springfield, ORBuilt 1990 · S/N 550-0639 N100FLGhs Leasing Co · Newport Beach, CABuilt 2001 · S/N 5510 N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559 N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535 N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957 N100WTFranklin Creek Investments LLC · Theodore, ALBuilt 1998 · S/N 550-0858 N100XVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 5320 N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N10123Sandy Wings LLC · Wilmington, DEBuilt 1971 · S/N 107 N101CANorton Energy Drilling LLC · Lubbock, TXS/N 425-0142 N101HLPapoose Air II LLC · Wilmington, DEBuilt 1981 · S/N 425-0056 N101JLLake Country Jet LLC · Waukesha, WIBuilt 2001 · S/N 550-1002 N101KFTravers 6 LLC · Chesterfield, MOS/N 5564 N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108 N101RERegistered aircraftBuilt 2017 · S/N 6101 N102ADEpic Crew LLC · Fort Worth, TXBuilt 1983 · S/N 4410311 N102DRCloud 9 LLC · Lafayette, LABuilt 1982 · S/N 551-0436 N102HBBuzz-Air Of Indiana Inc · Michigan City, INBuilt 1982 · S/N 550-0409 N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443 N1038S1038s LLC · Austin, TXBuilt 2008 · S/N 5782 N103CXBonaire Aviation LLC · Vestavia Hills, ALBuilt 1998 · S/N 550-0856 N104VVAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 53 N105FC4j Air LLC · Newark, DEBuilt 1981 · S/N 425-0094 N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31 N106SRSafari Intl LLC · Lewes, DEBuilt 1982 · S/N 550-0346 N107EEBlandco LLC · Greenville, SCBuilt 1991 · S/N 5500667 N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909 N1088Fmc Corp · Philadelphia, PABuilt 2009 · S/N 5798 N108ADMarquez Padilla Inc · Bonita, CABuilt 1983 · S/N 1080 N109DCFrog Force One LLC · Texico, NMBuilt 1998 · S/N 550-0832 N109GAFinancial Mistake Air LLC · Uvalda, GABuilt 1980 · S/N 550-0124 N109JCL&F Aviation LLC · Dallas, TXBuilt 1979 · S/N 550-0099 N109SBSabre Direct · Chicago, ILS/N 380-20 N10EGJarcav LLC · The Woodlands, TXBuilt 1979 · S/N 550-0055 N10FZAirflair Inc · Maurice, IABuilt 1981 · S/N 425-0117 N10KJKtkj Challenger LLC · Houston, TXBuilt 2020 · S/N 6155 N10LYAir & Water Research Corp · Wilmington, DEBuilt 1983 · S/N 550-0466 N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033 N10TCGardner Aviation LLC · Hot Springs, ARBuilt 1984 · S/N 550-0495 N10UHUniversity Of Alabama Board Of Trustees · Birmingham, ALS/N 550-0925 N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354 N110CPPruitt Corp · Leesburg, VABuilt 2024 · S/N 6211 N111AFWings Aloft Inc · Portland, ORBuilt 1981 · S/N 550-0256 N111CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 5192 N111GJMalik Hassan · Richfield, OHBuilt 1980 · S/N 5510187 N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226 N111LJSourek Trail Co Inc · Barberton, OHBuilt 1982 · S/N 550-0350

Back to AD 2001-22-14