Skip to content

Registered aircraft · 838

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-24-03-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-24-03-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-24-03-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-24-03-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-24-03-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-24-03-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.

N721RHRh · Wilmington, DEBuilt 2003 · S/N 5010 N723HAHagan Properties Inc · Louisville, KYBuilt 2005 · S/N 9165 N723HHAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2011 · S/N 9427 N724JJKoga Air LLC · San Luis Obispo, CABuilt 2009 · S/N 9357 N724MFMbf Leasing Of Florida LLC · Coral Gables, FLBuilt 2011 · S/N 9457 N726AFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 9352 N726BFWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 9268 N727PRCorporate Wings LLC · Cleveland, OHBuilt 2000 · S/N 613 N730BCDelta Air Lines Inc · Atlanta, GAS/N 55176 N730DDDpm Aviation LLC · Dover, DEBuilt 2008 · S/N 9287 N731SR83/80 LLC · New York, NYBuilt 2013 · S/N 9597 N73RPTransportation Holdings IV LLC · Dallas, TXBuilt 2015 · S/N 5528 N73ZZGlobal Aircraft II LLC · Eden Prairie, MNBuilt 1999 · S/N 593 N740SS740ss LLC · Tooele, UTBuilt 1997 · S/N 532 N7413BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9530 N74DHHalbert & Associates LLC · Irving, TXBuilt 2006 · S/N 9217 N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096 N757RRDirectional Capital LLC · Cleveland, OHBuilt 2016 · S/N 6213 N75CCNbi LLC · New Bremen, OHBuilt 2005 · S/N 5065 N75KHAmerican Fidelity Corp · Oklahoma City, OKBuilt 2012 · S/N 9505 N75VBParamount Pictures Corp · Van Nuys, CABuilt 2007 · S/N 9247 N765ATSapphire No5 LLC · Westlake Village, CABuilt 2004 · S/N 5063 N766PSPts Air LLC · Richmond Heights, OHBuilt 1997 · S/N 509 N767CWN767cw LLC · Camden, DEBuilt 1997 · S/N 520 N769WECd 321 LLC · Austin, TXBuilt 2004 · S/N 5048 N770AGUnited States Air Force · Hanscom Afb, MABuilt 2009 · S/N 9355 N770KFKw770 LLC · Bozeman, MTBuilt 2016 · S/N 9749 N771BKKaiser Aviation LLC · Waterford, MIBuilt 2010 · S/N 9382 N776MAGlf5 629 LLC · Wilmington, DEBuilt 2001 · S/N 629 N776RBFlower In The Field Av LLC · Santa Monica, CABuilt 1999 · S/N 585 N7777UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9591 N777ZHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6240 N778ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6289 N77NZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 9144 N780KSMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 5091 N780WGulfstream Gv-530 LLC · Wilmington, DEBuilt 1997 · S/N 530 N786JMPated LLC · Wilmington, DEBuilt 1999 · S/N 502 N786NMCd 321 LLC · Austin, TXBuilt 1997 · S/N 522 N787GPMalibu Consulting Corp · Beverly Hills, CABuilt 2001 · S/N 655 N787KJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 9741 N787NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9527 N788MMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9599 N789LRNordlys LLC · Bedford, NHBuilt 2006 · S/N 5100 N78SDLiquid Aviation Inc · Del Mar, CABuilt 2017 · S/N 9765 N793APCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 9454 N793XInvolo LLC · New York, NYBuilt 2014 · S/N 9605 N797CTCaterpillar Inc · Fort Worth, TXBuilt 2012 · S/N 9435 N797KBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9290 N79999Bank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6256 N799BCDelta Air Lines Inc · Atlanta, GAS/N 55170

Back to AD 98-24-03 R1