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.

N85VTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 595 N863CMWeh 601 LLC · Wilmington, DEBuilt 2021 · S/N 9488 N864JGBowtie Aircraft Xrs LLC · Aventura, FLBuilt 2019 · S/N 9864 N868KETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6272 N870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5076 N871FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 6304 N878SCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9614 N87WDWeeks-Davies Aviation Inc · West Palm Beach, FLBuilt 2001 · S/N 649 N880XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9806 N882PXNewage Aviation I LLC · Arcadia, CABuilt 2004 · S/N 5015 N882WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5576 N885KTJustifly LLC · Dallas, TXBuilt 2018 · S/N 6323 N886BPSun Air Three LLC · Scottsdale, AZBuilt 2011 · S/N 9453 N888HEGolden Sky Inc · Camden, DEBuilt 2001 · S/N 638 N888JELeone Management Inc · Camden, DEBuilt 2005 · S/N 5070 N889AHPasaca Capital Inc · Pasadena, CABuilt 1996 · S/N 512 N889CHPasaca Capital Inc · Pasadena, CABuilt 2015 · S/N 6118 N889KHInnova Aviation LLC · Pasadena, CABuilt 1998 · S/N 540 N889PGPrima Air Inc · Pasadena, CABuilt 2006 · S/N 9226 N88STTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2014 · S/N 9610 N890DACite Aviation LLC · Wilmington, DEBuilt 2005 · S/N 5079 N891ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55043 N892ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55044 N892BCDelta Air Lines Inc · Atlanta, GAS/N 55192 N892SSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6226 N893ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55045 N894ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55046 N895ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55047 N896ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55048 N898CHBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6277 N898JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6206 N898MDepartment Of The Air Force · Bedford, MABuilt 2024 · S/N 60156 N898NCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6125 N898STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6316 N899ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55049 N899YFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6127 N89CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 60041 N8VBCbs Mass Media Corp · Van Nuys, CABuilt 2012 · S/N 9490 N900ALTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 5500 N900LY6500 LLC · Pittsfield, MABuilt 2001 · S/N 661 N900SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9277 N901GXUnited States Air Force · Bedford, MAS/N 9001 N9046United States Government · Bedford, MABuilt 2021 · S/N 60056 N9047United States Government · Bedford, MABuilt 2022 · S/N 60087 N9048GUnited States Air Force · Bedford, MABuilt 2023 · S/N 60115 N904GBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 5101 N905JGLion Sky Aviation LLC · Studio City, CABuilt 2012 · S/N 9497 N906ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55087 N906FSBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 5521 N907GXLearjet Inc · Wichita, KSNon-citizen corporation, flight hours not reportedS/N 9007

Back to AD 98-24-03 R1