Skip to content

Registered aircraft · 783

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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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:91-20-14-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.

N783ZAZair Force One LLC · Mendenhall, MSBuilt 1998 · S/N FL-217 N784APDaniel C Salas Harvesting Inc · Hanford, CABuilt 2011 · S/N FL-747 N786SCBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N FL-1267 N787DKBlue Skies 4 LLC · Staunton, VAS/N FL159 N789LLUS Special Operations Command · Macdill Afb Tampa, FLBuilt 2003 · S/N FL-386 N78WCPro Equine Group Management LLC · Garland, TXBuilt 2016 · S/N FL-1079 N793FSWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N FL-793 N794UTUniversity Of Tennessee · Alcoa, TNBuilt 2008 · S/N FL-576 N7RCRing Air LLC · Dover, DEBuilt 2009 · S/N FL-621 N801GGLone Star Land & Cattle Co · Houston, TXBuilt 1993 · S/N FL-92 N802UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N FL-885 N805UPN357kg LLC · Winston Salem, NCBuilt 2013 · S/N FL-887 N806DBSouthern Aviation LLC · Spartanburg, SCBuilt 1990 · S/N FL-19 N807UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N FL-892 N80809Davis Aviation Inc DBA · Brandon, MSBuilt 2010 · S/N FL-729 N81025Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N FL-725 N810ECState Of Tennessee · Nashville, TNBuilt 2024 · S/N FL-1343 N8116NStingray Aviation LLC · Visalia, CABuilt 1991 · S/N FL-58 N811FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N FL-811 N811HDepartment Of Homeland Security · Washington, DCBuilt 2017 · S/N FM-73 N811WFWill Fire Holdings LLC · Dublin, GABuilt 2016 · S/N FL-1061 N8126LTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N FL-726 N81432Paragon Air Group · Fort Worth, TXBuilt 1991 · S/N FM-3 N81487Davis Aviation Inc DBA · Brandon, MSS/N FL-797 N814ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N FM-41 N814HSSasser M Stuart · Beeville, TXBuilt 2017 · S/N FL-1122 N816HDepartment Of Homeland Security · Washington, DCBuilt 2016 · S/N FM-67 N817PAAerolease LLC · Fargo, NDBuilt 1997 · S/N FL-174 N817PWN536mr LLC · Fort Worth, TXBuilt 2007 · S/N FL-536 N817TTBasham Investments LLC · Houston, TXBuilt 2006 · S/N FL-510 N817UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N FL-894 N818AGAvangrid Service Co · Orange, CTBuilt 2018 · S/N FL-1171 N819EEVaquero Skies LLC · El Paso, TXBuilt 1997 · S/N FL-187 N81PAPennsylvania Dept Of Transportation · New Cumberland, PABuilt 2019 · S/N FL-1196 N820UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-905 N821UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-908 N823EBIdi Aviation LLC · Indianapolis, INBuilt 1998 · S/N FL-227 N824UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-923 N825BLTailwinds LLC · Houston, TXBuilt 2012 · S/N FL-810 N825TTBank Of Utah Trustee · Salt Lake City, UTS/N FL-490 N825UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-925 N826FPMango Air 2 LLC · Oxnard, CABuilt 2000 · S/N FL-284 N826UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-926 N827UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-930 N828CJLasai Aviation LLC · Reston, VABuilt 2004 · S/N FL-406 N828PGPowell 737pg LLC · Baton Rouge, LABuilt 1999 · S/N FL-232 N828UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-932 N829CKUS Department Of Justice · Fort Worth, TXS/N FL-656 N82TPLjr Air LLC · Vineland, NJBuilt 2017 · S/N FL-1086 N830UPIsr Platforms LLC · Tysons, VABuilt 2014 · S/N FL-941

Back to AD 91-20-14 R1