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.

N388FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 636 N38NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2015 · S/N 5527 N393BZFalcon Holdings II LLC · Teterboro, NJBuilt 2011 · S/N 9444 N394HHHawk Hollow Farm LLC · Brighton, MIBuilt 2005 · S/N 9161 N394WJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9262 N3LBStellas Taxi LLC · Tampa, FLS/N 6123 N3LLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5080 N3MRDouble Leasing LLC · Oxford, CTBuilt 2014 · S/N 9650 N3PCJuniper Aviation III LLC · Coral Gables, FLBuilt 2010 · S/N 9399 N400BCBall Corp · Broomfield, COBuilt 2013 · S/N 9573 N401VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9320 N404NATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9356 N405LABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 5574 N40FPDnc Aircraft Holdings LLC · Wilmington, DEBuilt 2014 · S/N 9642 N40ZAHav Solutions LLC · Saint Petersburg, FLBuilt 2007 · S/N 9231 N410ATRegistered aircraftBuilt 2008 · S/N 9295 N411XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9133 N413JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9393 N415DSNexa Aviation LLC · Burlingame, CAS/N 5090 N416BDTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9375 N416ELC2 Aviation II LLC · Carson City, NVBuilt 2018 · S/N 6330 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 N420JGDuval Investments LLC · Southfield, MIBuilt 2002 · S/N 667 N421ALWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 9051 N427HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 662 N429CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9805 N43GX3td LLC · New York, NYBuilt 2009 · S/N 9343 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 N444DHHatley Aviation LLC · Johnson City, TNBuilt 2005 · S/N 5084 N445DBSa 6000 LLC · Hayward, CABuilt 2010 · S/N 9400 N445SKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9596 N446CCD&Tc LLC · Carlsbad, NMBuilt 2016 · S/N 6238 N44GXD3t2 LLC · New York, NYBuilt 2004 · S/N 9142 N44WGFalcon Aviation Z LLC · Great Neck, NYBuilt 2000 · S/N 9046 N459BEAdsum LLC · Dallas, TXBuilt 1998 · S/N 541 N459BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6321 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 N468KLMwm Consulting LLC · Wilmington, DEBuilt 2008 · S/N 9279 N469RRLegacy Aviation Inc · Camden, DEBuilt 2004 · S/N 5055 N46GXTexas Instruments Inc · Mc Kinney, TXBuilt 2011 · S/N 9469 N470BBReina Capital LLC · Miami, FLBuilt 2004 · S/N 9150 N472USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6198 N473USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6242 N474DMillard S Drexler Inc · Teterboro, NJBuilt 2005 · S/N 5083

Back to AD 98-24-03 R1