Registered aircraft · 68,369

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485RBreeden Wayne M · Memphis, TNBuilt 1975 · S/N AA1B-0585 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N14861Brown Helicopter Inc · Pensacola, FLBuilt 1972 · S/N 25089 N14863Asher Gerald W · N Richland Hills, TXS/N 7666 N1486RRiley Daniel B · Valparaiso, INBuilt 1975 · S/N AA1B-0586 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487RShepard William E · Peoria, AZS/N AA1B-0587 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489RSkidmark Services Inc · Debary, FLBuilt 1975 · S/N AA1B-0589 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148 N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008 N148BSHodges Mitchell · Powder Springs, GABuilt 2004 · S/N 20-1030 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N148DPHenke Kristen C · Bettendorf, IAS/N 11015C N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148GDDart Greg G · Mayville, NYBuilt 2001 · S/N 148 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148LMMoore Shelby L · Mount Pleasant, NCBuilt 2005 · S/N 5494 N148MHSmith Timothy Landon · Jonesville, NCBuilt 2017 · S/N 22570 N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005 N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008 N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148 N148TRegistered aircraftBuilt 1953 · S/N 18-2262 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282 N1491ASale Reported · Lone Jack, MOSale reportedBuilt 1952 · S/N 20-840 N1491PSale Reported · Oklahoma City, OKSale reportedBuilt 1956 · S/N 23-561 N1491RHerring Deems · Pine Mountain, GABuilt 1975 · S/N AA1B-0591 N1491TGreat Lakes Air Ventures LLC · Mason, MIBuilt 1972 · S/N 28-7205308 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1492AKessler David Keith · Mineral Wells, TXBuilt 1952 · S/N 22-400 N1492RHacker Delbert M Jr · Granbury, TXS/N AA1B-0592 N1492TLargo Logistics LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235305

Back to AD 90-04-06 R1