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.

N208PKSchuman Carriage Co Ltd · Honolulu, HIBuilt 2005 · S/N 208B1143 N208PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 20800511 N208RBCulebra LLC · Sioux Falls, SDBuilt 2013 · S/N 208B5073 N208RCRockwell Collins Leasing LLC · Cedar Rapids, IAFirst renewal noticeBuilt 2019 · S/N 208B5561 N208RFRandigo LLC · Wilmington, DEBuilt 1992 · S/N 208B0311 N208SAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2000 · S/N 208B0831 N208SMGrant Aviation Inc · Anchorage, AKBuilt 1999 · S/N 208B0749 N208SNStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2112 N208SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 208B1306 N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572 N208TFMartinaire Aviation LLC · Addison, TXBuilt 1997 · S/N 208B0592 N208TMRedding Aero Enterprises Inc · Redding, CABuilt 1994 · S/N 208B0413 N208TRSouth Aero Inc · Albuquerque, NMBuilt 2005 · S/N 208B1151 N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671 N208UUSpeedstar Express LLC · Carson City, NVBuilt 1997 · S/N 208B0604 N208VPN771at LLC · Lewes, DES/N 560-0208 N208WSilver Mountain LLC · Port Alsworth, AKBuilt 2015 · S/N 208B5224 N208WBAlgot Bernhard Ltd · Anchorage, AKS/N 208B2230 N208WFWipaire Inc · South Saint Paul, MNBuilt 2003 · S/N 208B1042 N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721 N208YYAircraft Structures International Corp · Enid, OKBuilt 1995 · S/N 208B0453 N208ZZSpeedstar Express LLC · Carson City, NVBuilt 1991 · S/N 208B0260 N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967 N209CV209cv LLC · Bozeman, MTBuilt 1993 · S/N 560-0209 N209JPBeta Fleet LLC · South Burlington, VTBuilt 2007 · S/N 20800409 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20AWWilliams Aviation Assets LLC · Jupiter, FLBuilt 2019 · S/N 208B5534 N20CCGunnslinger Air LLC · Destin, FLBuilt 1998 · S/N 560-0467 N20CRWestern Air International Corp · Fort Lauderdale, FLBuilt 1983 · S/N 097 N20CSChandan Dreamworks Inc · Wilmington, DES/N E-3601 N20DCKar Aviation LLC · New Albany, MSS/N 5250208 N20ERN20er LLC · Snellville, GABuilt 2011 · S/N FL-778 N20EWTriple H Aviation LLC · Milton, WVS/N FL-260 N20FDGilmer Aircraft Leasing LLC · Wilmington, DEBuilt 1998 · S/N LJ-1528 N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750 N20RMWeston Dante · Tequesta, FLS/N 501-0025 N20SA Paradise Repo LLC · Nokomis, FLBuilt 1978 · S/N LW-267 N20VLRusken Packaging Inc · Cullman, ALBuilt 1994 · S/N 525-0069 N20WPMoser Aircraft Service LLC · Huntington, INBuilt 1977 · S/N LJ-738 N20YLAstracc LLC · Corpus Christi, TXS/N 076 N2100EKovach David A Md · Greenwood, INBuilt 1971 · S/N E-290 N2106LCht Corp · Lake Forest, CABuilt 1976 · S/N E-878 N2107LN2107l LLC · Mishawaka, INBuilt 1976 · S/N E-879 N210CMJet Way LLC · Brooklyn, OHBuilt 1996 · S/N 560-0369 N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067 N210ECState Of Tennessee · Nashville, TNBuilt 1984 · S/N LJ-1070 N210EXUnited States Navy · Patuxent River, MDS/N FL-388 N210JLLopez Javier Jimenez · San Antonio, TXBuilt 1985 · S/N E-2208 N210MBSafe Flight LLC · Suwanee, GABuilt 1997 · S/N 525-0211

Back to AD 2006-16-18 R1