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.

N840SEGreen Fairways Florida Inc · Key West, FLBuilt 1979 · S/N 11610 N8481VLt Development Group LLC · Watford City, NDBuilt 1977 · S/N 2314R N848LGPia Avcenter LLC · Peoria, ILBuilt 1980 · S/N 11641 N849JSDel Mar College · Corpus Christi, TXBuilt 1988 · S/N 812 N850ACInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 11629 N8517AAirbus Ds Military Aircraft Inc · Mobile, ALBuilt 1981 · S/N 178 N8523VBain Aviation Inc · Weiser, IDBuilt 1976 · S/N 2283R N853NJN853nj LLC · Frankford, MOBuilt 1988 · S/N 1Z01811 N860MABab Leasing LLC · Summerfield, NCBuilt 1977 · S/N 700SA N866DAir 1st Aviation Companies Inc · Aiken, SCBuilt 1974 · S/N 656 N878JLConquest 878 LLC · Indianapolis, INBuilt 1982 · S/N 441-0293 N87WSKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1977 · S/N 441-0009 N87XCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 441-0133 N880ACN880ac LLC · Hastings, MIBuilt 1982 · S/N 1559SA N880GGarlynson Airways LLC · Lincoln, NEBuilt 1980 · S/N 95033 N88692Conquest Aircraft Leasing LLC · Carlsbad, CABuilt 1982 · S/N 441-0290 N887SDTesoro Capital LLC · High Point, NCBuilt 1984 · S/N 96207 N888SEAir 1st Inc · Aiken, SCBuilt 1982 · S/N 1549 S.A.N888WWVictory Aviation LLC · West Palm Beach, FLBuilt 1980 · S/N 791 S.A.N88GWWav Series LLC · Batavia, ILBuilt 1980 · S/N 441-0187 N88QTOrthoairways LLC · Westlake, TXBuilt 1981 · S/N 441-0228 N892SCDrs Sandra M Krokos And Thomas P Kislan Pc · Drums, PABuilt 1979 · S/N 392 S.A.N892WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 11273 N893KBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 415SA N8970NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 441-0092 N89DRN89dr LLC · Lowell, ARBuilt 1978 · S/N 713SA N89SCKcb Air LLC · Pendleton, INBuilt 1981 · S/N 1516 S.A.N8PQElkhorn Aviation Inc · Baker City, ORBuilt 1975 · S/N 11243 N901MCMs Merlin LLC · Dallas, TXS/N T369 N901TECheviot Holdings LLC · Key Largo, FLBuilt 1983 · S/N 15031 N905AAGraber Joel C · Collins, MSS/N TK65 N907JKN907jk LLC · Anchorage, AKBuilt 1980 · S/N 4410141 N907PASale Reported · Aurora, ORSale reported, canceledBuilt 2013 · S/N A6500003SC N907VMVmo LLC · Anchorage, AKS/N 1569SA N9089VWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC862M N909FSMj Aviation Inc · Walnut Ridge, ARBuilt 1995 · S/N G6-123 N910NFAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1973 · S/N 623 N911KCCounty Of Kern · Bakersfield, CABuilt 1975 · S/N 11300 N911XZSimmons & Associates · Hayward, CABuilt 2008 · S/N 0001 N913NL2242 Enterprises LLC · Dover, DES/N 15008 N9152XSchoenau Michael DBA · Tulare, CAS/N 1Z026-30 N915HAHeritage Ag LLC · Lakeview, MIBuilt 2013 · S/N G10-176 N916SJConquest Aviation LLC · Las Vegas, NVBuilt 1981 · S/N 441-0243 N91BFPlatinum Storage Properties LLC · Wayzata, MNBuilt 1981 · S/N 441-0245 N922HPColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1978 · S/N 441-0027 N937BBBravo Air LLC · Morristown, TNS/N 441-0248 N947LMAltisimo LLC · West Palm Beach, FLBuilt 1982 · S/N 15015 N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98 N94EA63nl LLC · Willmar, MNBuilt 1985 · S/N 96094 N950MD5-T Aviation LLC · Eunice, LABuilt 1981 · S/N AT-452B

Back to AD 89-07-07 R1