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.

N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033 N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032 N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593 N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298 N408ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41732 N408CJDt Management Group LLC · Phoenix, AZBuilt 2000 · S/N 293 N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194 N408RKPolar Palms LLC · Helena, MTBuilt 2015 · S/N 0860 N408SNUS Department Of State · Melbourne, FLS/N UE-408 N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645 N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556 N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293 N409ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41733 N409BMorris Danny L · Woodland, CABuilt 1948 · S/N D-1414 N409GVPa1 208b-1110 LLC · Fort Lauderdale, FLBuilt 2005 · S/N 208B1110 N409MNBohlke LLC · Kingshill, VIBuilt 2000 · S/N 208B0846 N409MSSale Reported · Nad Ap ShebaSale reportedBuilt 2020 · S/N 208B5578 N409RATurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N BB-429 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 N40CJInco Investments LLC · San Jose, CABuilt 2004 · S/N 525-0540 N40EAEagle Air Transport Inc · Ottawa, ILBuilt 1992 · S/N 20800084 N40EPIntrepid Air LLC · Las Vegas, NVBuilt 1989 · S/N 5510617 N40FJbk I LLC · Wayne, ILBuilt 1993 · S/N E-2793 N40GZAirtrex Aircraft Alpha Inc · Wichita, KSBuilt 2004 · S/N FL-400 N40JBElk River Aero LLC · Noel, MOS/N TH-338 N40JFIsr Aviation LLC · Wilmington, DEBuilt 1994 · S/N 208B0394 N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772 N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067 N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241 N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708 N40NERedding Aero Enterprises Inc · Redding, CABuilt 2000 · S/N 208B0874 N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7 N40RDAfh Interests LLC · Fort Worth, TXBuilt 2000 · S/N LJ-1615 N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878 N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09 N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190 N40URoss Stan W · Scandia, MNBuilt 1948 · S/N D-1336 N40XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N LJ-1640 N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278 N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026 N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411 N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166 N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605 N410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 421C1093 N410BMMottair LLC · Cincinnati, OHBuilt 2017 · S/N 208B5412 N410CAJustifications LLC · Wilmington, DEBuilt 1981 · S/N 31T-8166005 N410DMJmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 1992 · S/N 560-0184 N410GVPa1 208b-0632 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0632 N410HAWalega Jane Ellen · Essex, MDBuilt 1982 · S/N E-2035 N410LKBeachview Aviation LLC · Wilmington, DEBuilt 2009 · S/N FL-669

Back to AD 2006-16-18 R1