Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N350FPHff Partners LLC · Fresno, CABuilt 2012 · S/N FL-821 N350FWAir Excursions LLC · Chicago, ILBuilt 2013 · S/N FL-839 N350GACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1990 · S/N FL-16 N350GLWipaire Inc · South Saint Paul, MNBuilt 1999 · S/N FL253 N350GRJuliet Bravo Inc · Austin, TXBuilt 2001 · S/N FL-324 N350HCChildress Holdings LLC · Wilmington, DEBuilt 1991 · S/N FL-54 N350JSouthern Star Inc · Poteau, OKBuilt 1992 · S/N FL80 N350JFJdf Equipment Sales LLC · Lynn Haven, FLBuilt 2014 · S/N FL-973 N350JGBennie Air II LLC · Culbertson, NEBuilt 2008 · S/N FL-609 N350JPCanton Aviation LLC · Canton, OHBuilt 2014 · S/N FL-928 N350JWRegistration Pending · Middletown, DERegistration pendingBuilt 1998 · S/N FL-208 N350KN350k LLC · Sacramento, CABuilt 2010 · S/N FL-692 N350KABigups Aviation 011 LLC · Van Nuys, CABuilt 1999 · S/N FL-233 N350KDHerr Daniel Rhyne · Murray Hill, NJBuilt 1996 · S/N FL-136 N350KFTextron Aviation Inc · Wichita, KSBuilt 2014 · S/N FL-954 N350KGTenax Air Logistics LLC · Ridgeland, MSS/N FL-422 N350KSSedgwick County · Wichita, KSBuilt 2001 · S/N FL-323 N350KVWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N FL-319 N350MFayette Aviation LLC · Somerville, TNBuilt 1999 · S/N FL-247 N350MGRangeflyers Inc Trustee · Wichita, KSBuilt 2007 · S/N FL-528 N350MZClemens Aviation LLC · Wichita, KSBuilt 1990 · S/N FL-11 N350NYState Of New York · Albany, NYBuilt 2007 · S/N FL-539 N350PAS&S Ranch Inc · Mendota, CABuilt 2020 · S/N FL-1235 N350PJWhy Not LLC · Montezuma, KSS/N FL-384 N350PPEcr Software Corp · Boone, NCS/N FL-363 N350PTUS Special Operations Command · Macdill Afb Tampa, FLS/N FL-467 N350RCSt Michaels Aviation LLC · Athens, GABuilt 2012 · S/N FL-798 N350RKSouthern Farm Bureau Casualty Insurance Co · Ridgeland, MSBuilt 2010 · S/N FL-694 N350RROklahoma Steel And Wire Co Inc · Madill, OKBuilt 2009 · S/N FL-634 N350RTBig Chief Aviation LLC · Jasper, ALS/N FL-512 N350SJireh LLC · Wilmington, DEBuilt 1997 · S/N FL179 N350SES & J Aviation LLC · Wichita Falls, TXBuilt 2017 · S/N FL-1095 N350SKCsc Delaware Trust Co Trustee · Wilmington, DES/N FL-583 N350SMTenax Air Logistics LLC · Ridgeland, MSBuilt 2009 · S/N FL-474 N350SPSamaritans Purse · North Wilkesboro, NCBuilt 2013 · S/N FL-841 N350TBStephenson Richard J Trustee · Wheeling, ILBuilt 1973 · S/N E-413 N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62 N350TDGriffin Investment Co · Aliso Viejo, CABuilt 2007 · S/N FL-551 N350TFLamb Aviation LLC · Perris, CABuilt 1998 · S/N FL-202 N350TKTri State General Contractors Inc · Los Lunas, NMBuilt 1990 · S/N FL-5 N350VETvpx Ars Inc Owner Trustee · North Salt Lake, UTBuilt 2014 · S/N FL-970 N350VMHawk Aviation II LLC · Farmington Hills, MIBuilt 1991 · S/N FL-41 N350WCN350wc LLC · Clovis, NMBuilt 1994 · S/N 560-0266 N350WEBig Dog 350we LLC · Tucson, AZBuilt 1997 · S/N FL-189 N350WHRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2004 · S/N FL-394 N350WSTvpx Ars Inc Trustee · North Salt Lake, UTS/N FL-763 N350WVWorld Market Aviation LLC · Gulf Breeze, FLBuilt 2012 · S/N FL-786 N3518JJetran LLC · Horseshoe Bay, TXS/N 35108 N351ARWaco Air Holdings LLC · Warthen, GABuilt 2020 · S/N FL-1226 N351BCInternational Bank Of Commerce · Laredo, TXBuilt 1996 · S/N 525-0159

Back to AD 2006-16-18 R1