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.

N2190LSedine Aaron J · Cedar Springs, MIBuilt 1976 · S/N E-909 N2192LSiller Brothers Incorporated · Yuba City, CABuilt 1976 · S/N LW-192 N21955Pah 6 Inc · Houston, TXBuilt 2017 · S/N 208B5341 N2199LCardamone-Rayner Mark · Manistique, MIBuilt 1976 · S/N E-968 N219BSG Force Air LLC · Las Vegas, NVS/N FL-411 N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990 N219DKRegistered aircraftBuilt 1980 · S/N E-1599 N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536 N219HFAugusta Air II LLC · Fayetteville, NCBuilt 2016 · S/N 525-0907 N219JGInternational Jet Aviation Services Inc · Centennial, COS/N LJ-1470 N219RPMorrow Dennis J · Houston, TXBuilt 1976 · S/N E-885 N219TAValle Aviation Inc · Nashville, GABuilt 2004 · S/N 560-0669 N21BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 1983 · S/N BB-1115 N21CDTwo Two Lima LLC · Port Orange, FLBuilt 1968 · S/N E-28 N21CGN21cg Leasing LLC · Ponca City, OKBuilt 1989 · S/N BB-1346 N21CVBlu Sky Aviation LLC · Georgetown, TXBuilt 1995 · S/N 560-0340 N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980 N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117 N21DZBravo Hotel LLC · Lewes, DEFirst renewal noticeBuilt 1977 · S/N BC-32 N21ETDepucchio Mark V · Plainville, CTBuilt 1976 · S/N E-889 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N21HBN44af LLC · Wilmington, DEBuilt 2001 · S/N 560-0590 N21KGSuncrest Aviation LLC · Labelle, FLBuilt 1981 · S/N LA-149 N21KKLife'S A Beech LLC · Gulf Breeze, FLBuilt 1979 · S/N E-1563 N21LGTag Air LLC · Fort Worth, TXBuilt 1992 · S/N 5600197 N21LMN21lm LLC · Dover, DES/N 560-0117 N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848 N21MFOsgood Air LLC · Hays, KSBuilt 1998 · S/N TH-1871 N21RFN21rf LLC · Saint Louis, MOBuilt 2019 · S/N FL-1182 N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039 N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473 N21TKMtk Leasing LLC · Woodburn, ORS/N 525-0131 N21TVEffaircy Aviation LLC · Huntsville, ALBuilt 1995 · S/N 560-0337 N21VCCitation Hawk LLC · Moody, ALBuilt 1995 · S/N 525-0106 N21VRJb Aviation LLC · Baton Rouge, LABuilt 1989 · S/N E-2468 N21WPAir Dryden LLC · Dothan, ALBuilt 1972 · S/N E-336 N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650 N21YMCape Fear Transport Inc · Elizabethtown, NCS/N TH-2005 N2207LHautman John M · Oxnard, CABuilt 1976 · S/N E-915 N22097Crestair Air LLC · Dover, DEBuilt 1977 · S/N E-1169 N220BPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N S550-0034 N220CGOffshore Energy Services Inc · New Iberia, LAS/N FL-397 N220CVDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1988 · S/N 220 N220EAEagle Air Transport Inc · Ottawa, ILS/N 208B0151 N220FSHonker Air LLC · Huntingburg, INS/N FL-1217 N220GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-220 N220JJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 258475 N220JLJuliet Charlie LLC · Wolf Creek, MTS/N 525-0020 N220KWAirselect LLC · West Point, IABuilt 1983 · S/N BB-1120 N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063

Back to AD 2006-16-18 R1