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.

N344PPWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31272 N344RCHome Perfection General Contractors Inc · Pelham, ALBuilt 1984 · S/N TH-1412 N344SRegistered aircraftBuilt 1972 · S/N TH-210 N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424 N345CFLowery Ron L · Batesville, ARS/N E-2532 N345CKCklass Transport Inc · Chula Vista, CABuilt 1990 · S/N FL-18 N345CRAlbion Aviation LLC · Florence, SCBuilt 1994 · S/N E-2873 N345DWalker Benjamin Kelly · Myrtle Beach, SCBuilt 1988 · S/N E-2422 N345DGRfp Enterprises Inc · Bridge City, TXBuilt 2005 · S/N FL-427 N345PGN345pg LLC · Chicago, ILBuilt 2001 · S/N TH-2016 N345URegistered aircraftBuilt 1971 · S/N E-263 N346BALwcr Transportation Inc · Minot, NDBuilt 1999 · S/N BB-1653 N346EXWebair LLC · Warrenton, VAS/N 346 N346PRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31273 N3477ARagsdale Lincoln J Jr · Phoenix, AZBuilt 1969 · S/N E-183 N347BCRoni 1 LLC · Sacramento, CABuilt 2001 · S/N 525-0431 N347GAJp Flying LLC · Dover, DEBuilt 1981 · S/N 347 N347KAKamaka Air LLC · Honolulu, HIBuilt 2012 · S/N 208B2407 N347MHStallion 501 LLC · Wilmington, DEFirst renewal noticeS/N 501-0155 N3489Vspa Citation Holdings LLC · Davie, FLBuilt 1985 · S/N S550-0055 N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334 N348TFli Aero Ltd · New Lebanon, OHBuilt 1976 · S/N E-908 N349CAMetrea Special Aerospace Isr Inc · Bethany, OKBuilt 2002 · S/N FL-349 N349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202 N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036 N34AGJ D Aviation Leasing LLC · Mundelein, ILS/N 421C0901 N34CEFirst Call Home Health Agency LLC · Salem, ORBuilt 1981 · S/N LJ-932 N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836 N34LTPaper Boys LLC · Dover, DEBuilt 1992 · S/N BB-1437 N34MFDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-163 N34RLKar2 Inc · Sevierville, TNBuilt 2017 · S/N 525-0948 N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943 N34TCHuff Air LLC · Uvalde, TXBuilt 1994 · S/N 5250083 N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41 N34UPCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N BC-006 N3509RAnalog Yankee LLC · Boulder, COBuilt 1989 · S/N 560-0024 N3509W92nd West Aviation Inc · Lonoke, ARS/N TH-350 N350ABGolden Eagle One LLC · Garden City, KSBuilt 1998 · S/N FL-212 N350AEWcp Developers LLC · Clovis, CABuilt 2013 · S/N FL-848 N350AFTechnav LLC · Columbus, INBuilt 1997 · S/N FL-184 N350ALBrownstone Aviation LLC · Houston, TXBuilt 2015 · S/N FL-1039 N350BBRtd Air LLC · Hernando, MSBuilt 1990 · S/N FL-22 N350BDParrot Air LLC · Corpus Christi, TXBuilt 1994 · S/N FL-123 N350BSKa Partners LLC · Thomson, GABuilt 1990 · S/N FL-6 N350BWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N FL-278 N350BZLogistics Business Services LLC · Cheshire, CTBuilt 2011 · S/N FL-771 N350CFClemens Aviation LLC · Wichita, KSS/N FL-57 N350DRDeroyal Industries Inc · Powell, TNBuilt 1991 · S/N FL63 N350ESAdvanced Air LLC · Hawthorne, CABuilt 2010 · S/N FL-703 N350FCModern Industrial Services Inc · Beaumont, TXBuilt 1998 · S/N FL-214

Back to AD 2006-16-18 R1