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.

N303BDFjb 16720 LLC · The Woodlands, TXBuilt 2004 · S/N 5058 N305LMHga LLC · Dallas, TXBuilt 2001 · S/N 1443 N306MASc Aviation LLC · Austin, TXBuilt 2007 · S/N 9225 N307MALive Holdings A1 LLC · Windermere, FLBuilt 2013 · S/N 9550 N311NBCisco Aero - N9410 LLC · Cisco, TXBuilt 2010 · S/N 9410 N312AFBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9551 N3131A313 Aviation Holdings LLC · Miami Beach, FLBuilt 2003 · S/N 5021 N313BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 9108 N313RFWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9194 N313RGRenair 650 LLC · New York, NYBuilt 2017 · S/N 6262 N316FSea To Sea Aviation LLC · Dallas, TXBuilt 2003 · S/N 5007 N316VAAvation LLC · Grand Rapids, MIBuilt 2015 · S/N 5530 N318LSRegistered aircraftBuilt 2016 · S/N 6204 N319GGGg Aviation LLC · San Luis Obispo, CABuilt 2000 · S/N 9070 N319PEPlus3 Aviation LLC · West Hollywood, CABuilt 2016 · S/N 6219 N321VCRegistered aircraftBuilt 2009 · S/N 9339 N321WAWinchester Air Inc · Winchester, MABuilt 2018 · S/N 9852 N3251KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6192 N325APTalaria Logistics LLC · Denver, COBuilt 2017 · S/N 6276 N3262TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9254 N326GXKelgen Partnership Llp · Milwaukee, WIBuilt 2009 · S/N 9326 N329SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6224 N330KCRegistered aircraftBuilt 2013 · S/N 9579 N333GWBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6099 N336EBJ C Flowers & Co LLC · New York, NYBuilt 2015 · S/N 5525 N336LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2000 · S/N 5081 N337LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5099 N340FLHines Hill Aviation LLC · Boston Heights, OHBuilt 2000 · S/N 612 N342ZKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6135 N343DFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 9702 N34681Registered aircraftBuilt 2014 · S/N 9634 N34HSHs Arrow LLC · Indianapolis, INBuilt 2015 · S/N 5514 N351LSCombined Aircraft Ownership LLC · Fargo, NDBuilt 2000 · S/N 9050 N358VUS Bank Na · Marshall, MNBuilt 2015 · S/N 6161 N360HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9344 N3618KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9449 N363JGIrongate Air LLC · Los Angeles, CABuilt 2000 · S/N 594 N365BFN365bf LLC · New York, NYBuilt 1998 · S/N 544 N365CJTashi Corp · Oakland, CABuilt 2000 · S/N 9077 N365LVAult Aviation LLC · Las Vegas, NVBuilt 2005 · S/N 5094 N36GVRegistered aircraftBuilt 2002 · S/N 674 N36MMJags Leasing LLC · Piscataway, NJBuilt 2007 · S/N 9244 N372BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9413 N373GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9807 N373VBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9420 N375WB9288 Corp Trustee · Wilmington, DEBuilt 2008 · S/N 9288 N378LTTvpx 2022 Msn 9218 Business Trust · North Salt Lake, UTBuilt 2006 · S/N 9218 N37LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 9164 N37NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2018 · S/N 5580 N3877821 393 LLC · Vienna, VABuilt 2008 · S/N 9304

Back to AD 98-24-03 R1