Registered aircraft · 726

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

N431CBCamellot Aviation II LLC · Emerald Isle, NCBuilt 2006 · S/N 560-5629 N432KSSsk Management 2 LLC · Bedford, OHBuilt 2001 · S/N 560-5169 N447CCPace Aviation Corp · Chesapeake, VABuilt 2003 · S/N 560-5349 N44GT44gt LLC · Enid, OKBuilt 2012 · S/N 560-6122 N452MMo Says LLC · Farmingdale, NYBuilt 2001 · S/N 560-5176 N454MMElement40 Aviation LLC · Memphis, TNBuilt 2007 · S/N 560-5737 N455GCUniversity Of South Carolina · Columbia, SCBuilt 2014 · S/N 560-6151 N456TCMaizy Aviation LLC · Pearland, TXBuilt 2006 · S/N 560-5634 N45NSSeaman Corp · Wooster, OHBuilt 2002 · S/N 560-5285 N460SNovant Health Inc · Winston Salem, NCBuilt 2025 · S/N 560-6377 N461PSOmni Air LLC · Chesapeake, VABuilt 2000 · S/N 560-5059 N469MRBcrh LLC · Owasso, OKBuilt 2000 · S/N 560-5125 N469RSMdx Leasing LLC · Pompano Beach, FLBuilt 2000 · S/N 560-5082 N46FBSfblic Aviation LLC · Jackson, MSS/N 560-6362 N475CWTeam Aero LLC · Shawnee, KSBuilt 2000 · S/N 560-5080 N476JCBas Part Sales LLC · Greeley, COBuilt 2011 · S/N 560-6095 N47EKL J Associates Inc · Latrobe, PABuilt 2013 · S/N 560-6147 N47HFCitation Msn 560-5153 LLC · Wilmington, DEBuilt 2003 · S/N 560-5347 N484JCWhitefish Investment Partners LLC · Frisco, TXBuilt 2006 · S/N 560-5646 N485ATAdvanced Technology Services Inc · Peoria, ILBuilt 2012 · S/N 560-6103 N486TTThompson Tractor Co Inc · Birmingham, ALBuilt 2006 · S/N 560-5635 N491JLLoacker Carolynn · Portland, ORBuilt 2014 · S/N 560-6181 N497MNHeavenly Express LLC · Winnetka, ILBuilt 2019 · S/N 560-6263 N499AVTeton Leasing LLC · Pocatello, IDBuilt 2005 · S/N 560-5602 N4KSOa Air LLC · Lincoln, NEBuilt 1999 · S/N 560-5035 N4RPN4rp LLC · Missoula, MTBuilt 2017 · S/N 560-6227 N500JDBeneficial Endeavors LLC · Wilmington, DEBuilt 2005 · S/N 560-5589 N500SXMerlin Aviation LLC · Indianapolis, INBuilt 1999 · S/N 560-5018 N500WGCitation Msn 560-6343 LLC · Wilmington, DEBuilt 2023 · S/N 560-6343 N500XLAbd Equipment LLC · Aledo, TXBuilt 2003 · S/N 560-5335 N501UPCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 560-5252 N502BCOnarco2 LLC · Maurice, IABuilt 2000 · S/N 560-5098 N502EGX-Ray Lima Sierra LLC · Springfield, MOBuilt 2004 · S/N 560-5502 N502UPAlliance Aviation Group LLC · Wilmington, DEBuilt 2003 · S/N 560-5310 N502XLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 560-6502 N503QFLmm Holding LLC · Cincinnati, OHBuilt 2001 · S/N 560-5205 N504KHFms Management Systems LLC · Dover, DEBuilt 2023 · S/N 560-6341 N504SNSana Capital Holdings Delaware LLC · Dover, DES/N 560-5332 N504WGTextron Aviation Inc · Wichita, KSBuilt 2024 · S/N 560-6355 N505WG505wg LLC · Wilmington, DEBuilt 2024 · S/N 560-6356 N508UPCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5546 N50CUUnited Bottling Management Co LLC · Birmingham, ALBuilt 2022 · S/N 560-6319 N50EKLj Associates Inc · Latrobe, PABuilt 2012 · S/N 560-6112 N50RRTextron Aviation Inc · Wichita, KSS/N 560-6522 N510RCRc Aviation Services Inc · San Juan, PRBuilt 2015 · S/N 560-6197 N510TKTk Constructors Inc · Muncie, INBuilt 2000 · S/N 560-5091 N511WRAir Wilderness LLC · Wisconsin Dells, WIBuilt 2024 · S/N 560-6359 N512LLMcminn Law Firm Llp · Austin, TXBuilt 1999 · S/N 560-5023 N513CCAir Floss One LLC · Carrollton, TXBuilt 2007 · S/N 560-5678 N513VVInterstate Aviation LLC · Henderson, NVBuilt 2000 · S/N 560-5126

Back to AD 2012-06-01