Skip to content

Registered aircraft · 523

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:2020-03-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21') 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:2020-03-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21')
  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:2020-03-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21')
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.

N4139HUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 60181 N413JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9393 N416BDTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9375 N417CSWpa Aviation II LLC · Greenwich, CTBuilt 2007 · S/N 9255 N417LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60004 N420AGDodson International Parts Inc · Rantoul, KSBuilt 1998 · S/N 9006 N421ALWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 9051 N423JLNardo LLC · Opa Locka, FLBuilt 2024 · S/N 60138 N429CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9805 N43GX3td LLC · New York, NYBuilt 2009 · S/N 9343 N442LFWilmington Trust Co Trustee · Wilmington, DES/N 9567 N443PRRuffin Development Acquisitions LLC · Wichita, KSBuilt 2012 · S/N 9520 N4444XRegistered aircraftBuilt 2018 · S/N 9824 N444BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9241 N445DBSa 6000 LLC · Hayward, CABuilt 2010 · S/N 9400 N445SKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9596 N44GXD3t2 LLC · New York, NYBuilt 2004 · S/N 9142 N44WGFalcon Aviation Z LLC · Great Neck, NYBuilt 2000 · S/N 9046 N45BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 9207 N45GXTexas Instruments Inc · Mc Kinney, TXBuilt 2011 · S/N 9459 N468GCTryst Aviation LLC · San Juan, PRBuilt 2013 · S/N 9558 N468GHGrosvenor Holdings LLC · Chicago, ILBuilt 2024 · S/N 60142 N468KLMwm Consulting LLC · Wilmington, DEBuilt 2008 · S/N 9279 N46GXTexas Instruments Inc · Mc Kinney, TXBuilt 2011 · S/N 9469 N470BBReina Capital LLC · Miami, FLBuilt 2004 · S/N 9150 N474TCJep Holdings LLC · Oklahoma City, OKBuilt 2013 · S/N 9601 N487JGArtemis Aviation LLC · Houston, TXBuilt 2012 · S/N 9487 N48WGAlliance Aviation Group LLC · Wilmington, DEBuilt 2004 · S/N 9148 N490BACisco Aero - N9739 LLC · Cisco, TXBuilt 2015 · S/N 9739 N496XNrc Logistics LLC · Salt Lake City, UTBuilt 2022 · S/N 60063 N497ECEdf LLC · New York, NYBuilt 2010 · S/N 9396 N497HYRegistered aircraftN-number assigned (import), not yet registeredS/N 60230 N499WREagle One II LLC · King Of Prussia, PABuilt 2011 · S/N 9458 N5000PGeo Leasing LLC · Boca Raton, FLBuilt 2014 · S/N 9655 N500EURegistered aircraftBuilt 2018 · S/N 9838 N500VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9552 N501APLogistical Executive Solutions LLC · Salt Lake City, UTS/N 60001 N501MGRegistered aircraftBuilt 2006 · S/N 9215 N501VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9563 N502VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9608 N503VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9565 N504GBBenson Football LLC · Metairie, LABuilt 2024 · S/N 60152 N504VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9566 N505VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9571 N506VJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2006 · S/N 9214 N507VJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2011 · S/N 9446 N50VCBoulder Haven LLC · Dallas, TXBuilt 2013 · S/N 9539 N513DLPnc Financial Services Group Inc · Pittsburgh, PABuilt 2017 · S/N 9786 N513TFEac Air LLC · New York, NYBuilt 2012 · S/N 9508 N514NBAlten Consulting LLC · Fort Lauderdale, FLBuilt 2020 · S/N 60036

Back to AD 2020-03-21