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.

N831ATAero 3 LLC · New London, NCBuilt 2021 · S/N FL-1270 N831LSMojave Aviation LLC · Fort Wayne, INS/N FL-390 N831UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-943 N832UPAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2014 · S/N FL-945 N833CCAlc Air LLC · Irvine, CABuilt 2022 · S/N FL-1306 N833UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-947 N834UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-963 N835UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-965 N836UPKansas State University · Salina, KSBuilt 2014 · S/N FL-966 N838UPTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2015 · S/N FL-980 N83KBTechnology Service Corp · Arlington, VABuilt 2008 · S/N FL-616 N83KEAirtrex Registration Corp Trustee · Wichita, KSS/N FL-436 N840CAMetrea Special Aerospace Isr Inc · Bethany, OKS/N FL-104 N841UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-987 N842CTCenac Towing Co LLC · Houma, LABuilt 2019 · S/N FL-1174 N842EXUnited States Navy · Patuxent River, MDBuilt 2005 · S/N FL-456 N843FSWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N FL-843 N844CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N FL-350 N845KACrowther Air LLC · Fort Myers, FLBuilt 2013 · S/N FL-845 N846DJHeritage Aviation Management Ltd · Conroe, TXBuilt 1992 · S/N FM-7 N846YTTrue Drilling LLC · Casper, WYBuilt 2008 · S/N FL-617 N847YTTrue Drilling LLC · Casper, WYBuilt 2025 · S/N FL-1361 N848GTTrovarsi Ltd LLC · Balch Springs, TXBuilt 2008 · S/N FL-577 N848UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-1004 N849UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-1006 N84LELife Logistics LLC · Chesterfield, MOS/N FL-483 N84LFLife Logistics LLC · Chesterfield, MOBuilt 2022 · S/N FM-108 N850DTalfin Leasing LLC · Heflin, ALBuilt 1992 · S/N FL-70 N850UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-992 N853BN853b LLC · Kalispell, MTBuilt 2010 · S/N FL-719 N855UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-1024 N855VGM T B Investments LLC · Idaho Falls, IDBuilt 2008 · S/N FL-601 N856UPJjg Civil LLC · Thibodaux, LABuilt 2015 · S/N FL-1029 N85FCFlow Companies LLC · Winston Salem, NCBuilt 2018 · S/N FL-1170 N860HState Of Ohio Department Of Transportation · Columbus, OHBuilt 2015 · S/N FL-977 N860TTWlf Aviation LLC · Stratford, CABuilt 1992 · S/N FL-86 N864CACarver Aero LLC · Muscatine, IAS/N FL-396 N865LRKirmart Inc · Wichita Falls, TXS/N FL-471 N865SHSafe Harbor Aviation LLC · Knoxville, TNBuilt 2012 · S/N FL-820 N867UPNorth County Flying LLC · North Palm Beach, FLBuilt 2017 · S/N FL-1098 N86BBMile High Adventures LLC · Yazoo City, MSBuilt 1993 · S/N FL-107 N86FDKa Equipment LLC · Charlotte, NCBuilt 2012 · S/N FL-822 N86GALamarque Citation X LLC · Kenner, LABuilt 1993 · S/N FL100 N870STPennsylvania State Police · Hershey, PAS/N FL-1305 N871UBFub Air LLC · Lubbock, TXS/N FL-762 N875BRenson Travel LLC · San Antonio, TXBuilt 2013 · S/N FL-875 N878CTCarog II LLC · Wilmington, DEBuilt 2013 · S/N FL-858 N880STTextron Aviation Inc · Wichita, KSS/N FL-1371 N880UPNebraskaland Tire Inc · Wichita, KSBuilt 2018 · S/N FL-1127 N883GBTica Travel LLC · Tampa, FLBuilt 2007 · S/N FL-520

Back to AD 91-20-14 R1