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.

N799GSSms 111 LLC · New York, NYBuilt 2006 · S/N 9192 N799JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60032 N79AYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 9058 N7CGCoulson Aviation (USA) Inc · Portland, ORBuilt 2000 · S/N 9075 N7HARegistered aircraftBuilt 2015 · S/N 6172 N7SESteven Brothers Aviation LLC · Wichita, KSBuilt 2005 · S/N 5088 N800HCSouthern Valhalla Air LLC · The Colony, TXBuilt 2011 · S/N 9460 N800JHJ&J Aviation LLC · Crested Butte, COBuilt 2005 · S/N 5073 N801ASRegistered aircraftBuilt 2005 · S/N 5097 N801PNSabrina Aviation Corp · Boston, MABuilt 2000 · S/N 9062 N802BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9644 N803HHHogs Head Air III LLC · New York, NYBuilt 2002 · S/N 665 N805TMTai Leasing Inc · Mckinney, TXBuilt 2016 · S/N 6236 N806HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9796 N808JGTwo Weeks Notice LLC · Miami Lakes, FLBuilt 2000 · S/N 598 N808LVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6152 N80ADArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 5539 N80PNBkf Aviation Ltd · Boston, MABuilt 1999 · S/N 576 N80TEBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 60006 N811TMTai Leasing Inc · Mckinney, TXBuilt 2017 · S/N 6281 N812RBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5045 N814RGWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 9736 N817BCDelta Air Lines Inc · Atlanta, GAS/N 55171 N818AATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9347 N820BCDelta Air Lines Inc · Atlanta, GAS/N 55173 N820HBNasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1999 · S/N 570 N820MSSpeedero LLC · Hillsboro, ORBuilt 2000 · S/N 626 N82123Bank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 6344 N821SCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5030 N822BDKoba LLC · Paradise Valley, AZBuilt 2005 · S/N 5064 N822VPVp LLC · Camden, DEBuilt 1999 · S/N 9016 N826BCHawaiian Airlines Inc · Honolulu, HIS/N 55183 N827TFAvandra LLC · Salt Lake City, UTBuilt 2011 · S/N 9439 N829ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6338 N82AUS Bank N A Trustee · Boston, MABuilt 2016 · S/N 6188 N82EMJdi Holdings LLC · Allentown, PABuilt 2007 · S/N 9239 N82HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60028 N830NRCalico G550 LLC · North Miami, FLBuilt 2008 · S/N 5201 N832PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9837 N835HCHood Capital LLC · Hattiesburg, MSBuilt 2017 · S/N 6292 N838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1999 · S/N 9035 N83VPRegistered aircraftBuilt 2000 · S/N 614 N83WGCooper Burger LLC · Coral Gables, FLBuilt 1999 · S/N 9030 N843FFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9574 N843GXAlesant Air LLC · Miami, FLBuilt 1999 · S/N 9026 N846CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6269 N848JAD S Advisors Inc · Oak Park, ILBuilt 2004 · S/N 5047 N84YUTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9300 N85DRegistered aircraftBuilt 2001 · S/N 9078 N85NVKhosla Ventures LLC · San Jose, CABuilt 1997 · S/N 513

Back to AD 98-24-03 R1