Registered aircraft · 673

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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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:89-07-07-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.

N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006 N445DFUsda Forest Service Fepp · Mcclellan, CABuilt 2004 · S/N 152345 N448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425527034 N4490MIndian Ink Leasing Inc · Amarillo, TXBuilt 1979 · S/N BE-64 N449BKMu2b40 LLC · Rancho Santa Fe, CABuilt 1981 · S/N 449 S.A.N44AFTrinity Group · Watford City, NDBuilt 1981 · S/N 790SA N44MXRiver City Aviation Inc · Fairdealing, MOBuilt 1981 · S/N 1526 S.A.N450DFUsda Forest Service Fepp · Mcclellan, CABuilt 2005 · S/N 152341 N456GTConquest 294 LLC · Wilmington, DEBuilt 1982 · S/N 441-0294 N459RJTurkey Track Ranch Management LLC · Amarillo, TXBuilt 1981 · S/N TT459A N459SASolitaire Leasing LLC · Evanston, ILS/N 459 S.A.N461MAGood Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 301 N461TMSpearman Michael · The Woodlands, TXBuilt 1984 · S/N 46-8408050 N462MARegistered aircraftBuilt 1974 · S/N 302 N466DCAerotel Inc · Spring Hill, FLBuilt 1981 · S/N 1528SA N466SMMiddleton Lee Sam · Lubbock, TXBuilt 1982 · S/N 441-0300 N467CSNational Aircraft LLC · Colorado Springs, COBuilt 1981 · S/N 167 N467MAAlc Aviation LLC · Cheyenne, WYS/N 1567SA N468SGGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2024 · S/N GA-6-1554 N46AKExpress Aviation Management LLC · Dover, DEBuilt 1979 · S/N 754S.A.N46HLGsp Air LLC · Sparta, NJBuilt 1985 · S/N 42-5527017 N46LHSkyventure Arizona LLC · Reno, NVBuilt 1974 · S/N SH-1927 N470SGGeneral Atomics Aeronautical Systems Inc · Poway, CAS/N GA-6-1557 N471SGGeneral Atomics Aeronautical Systems Inc · Poway, CAS/N GA-6-1558 N478XPParaclete Aviation LLC · Raeford, NCBuilt 1982 · S/N 272 N479PTT Enterprises Inc · Jackson, MSBuilt 1981 · S/N 96011 N479SGGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2024 · S/N GA-6-1592 N47EPRum Bum Distributors Inc · Miami, FLBuilt 1978 · S/N 11520 N47ZGJep Air LLC · Jackson, WYBuilt 1985 · S/N 42-5527031 N480SGGeneral Atomics - Aeronautical Systems Inc · Poway, CABuilt 2024 · S/N GA-6-1635 N483AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1973 · S/N 271 N485AFLaver Michael · Glendale, AZBuilt 1974 · S/N 308 N486MTNavy 8686 LLC · Boston, MABuilt 1985 · S/N 425527029 N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333 N487UEAircraft Propulsion Leasing LLC · Holland, OHBuilt 1990 · S/N 906 N488SGGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2025 · S/N GA-6-1604 N489AFLaver Michael · Glendale, AZS/N 243 N48NPJere Aviation LLC · Fond Du Lac, WIBuilt 1981 · S/N 447 S.A.N490EKGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2021 · S/N GA-6-1514 N495CSAero Brothers LLC · Colorado Springs, COBuilt 1981 · S/N 195 N496PTPlane Folk LLC · Klamath Falls, ORS/N AT-427 N497CASpore Ltd LLC · Colorado Springs, COBuilt 1983 · S/N 291 N499SPSamaritans Purse · Boone, NCBuilt 1982 · S/N 263 N4NEP M Leasing Inc · Perris, CABuilt 1970 · S/N SH1885 N4RRough Ryder Aircraft Inc · Carmel, NYBuilt 1981 · S/N 1542 S.A.N4WDHat Creek Aviation LLC · Hamilton, MTBuilt 1979 · S/N 399 S.A.N500ERConquest II LLC · Kenner, LABuilt 1979 · S/N 441-0084 N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668 N5016HBest Aircraft Deals LLC · Salt Lake City, UTS/N 11452 N502AKProvost Michael A · Jefferson, GABuilt 1997 · S/N V55-896T

Back to AD 89-07-07 R1