Skip to content

Registered aircraft · 961

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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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.

N734CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1993 · S/N 25858 N7352CCsds Asset Management LLC · Rllng Hls Est, CAS/N 26340 N7353CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27634 N7354CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27425 N735EDynamic Aviation Group Inc · Bridgewater, VAS/N 26339 N735TDynamic Avlease Inc · Bridgewater, VABuilt 1990 · S/N 24651 N73HKWilmington Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 21957 N74007United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29477 N740ASAlaska Aviation Museum · Anchorage, AKBuilt 1981 · S/N 22578 N740AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22213 N742CKKalitta Air LLC · Ypsilanti, MIS/N 24424 N743CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26350 N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221 N744CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26353 N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222 N745CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26361 N746AAMidnight Engineering LLC · Fort Lauderdale, FLS/N 26639 N7470Museum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20235 N747GFGe Engine Leasing Holdings Inc · Cincinnati, OHBuilt 1994 · S/N 26355 N747SFAerospace Trust Management LLC Trustee · Wilmington, DES/N 21575 N74856United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32815 N749AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22226 N749BCAlta 777 LLC · Salt Lake City, UTS/N 33372 N750ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30259 N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227 N751ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30798 N752ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30260 N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434 N752CXCargo Aircraft Management Inc · Wilmington, OHS/N 24451 N752LTL-3 Communications Advanced Aviation LLC · Kalispell, MTS/N 26058 N753ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30261 N754ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30262 N755ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30263 N755CSCsds Asset Management LLC · Rllng Hls Est, CAS/N 25014 N756AMAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30264 N756CAAc Spe 4 LLC · Orlando, FLBuilt 1991 · S/N 26547 N757ABoeing Logistics Spares Inc · Seattle, WABuilt 1982 · S/N 22212 N757AFDjt Operations I LLC · West Palm Beach, FLBuilt 1991 · S/N 25155 N757ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32636 N757HWHoneywell Aerospace US LLC · Phoenix, AZBuilt 1982 · S/N 22194 N757SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 22176 N75851United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32810 N75853United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32812 N75854United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32813 N75858United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32817 N758ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32637 N758SSRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1992 · S/N 26647 N759ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32638 N76010United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29480 N76021United Airlines Inc · Chicago, ILBuilt 2010 · S/N 39776

Back to AD 98-13-12 R1