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.

N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761 N2111QKnapp Christian K · Lyons, COBuilt 1969 · S/N E-135 N2112VRegistered aircraftS/N FL-501 N2114GMission Aviation Fellowship · Nampa, IDBuilt 1999 · S/N 208B0782 N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759 N211CGAzul Air LLC · Dover, DES/N LW-101 N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166 N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211 N211GSInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 021 N211LGStaggerwing Holdings LLC · Englewood, COBuilt 2000 · S/N BB-1732 N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244 N2123LPanther Air LLC · Alameda, CABuilt 1976 · S/N E-886 N212AGSea Aviation Holdings LLC · Wilmington, DEBuilt 2007 · S/N 258821 N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995 N212CHFlycarolina Ll · Concord, NCBuilt 1980 · S/N TH-1165 N212CPTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1996 · S/N 208B0531 N212FJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 147 N212HCHcc Air LLC · Las Vegas, NVS/N BB-1791 N212LWPf Aviation LLC · Carl Junction, MOBuilt 2001 · S/N BB-1766 N212MN212m LLC · Senatobia, MSBuilt 1977 · S/N 501-0280 N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209 N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604 N212RHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 525-0636 N212RVMinuteman 12 LLC · Wilmington, DES/N 421C0684 N212TDDevane David B Trustee · East Falmouth, MABuilt 1982 · S/N E-1944 N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950 N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093 N2134LHeyen John M · Springfield, ILBuilt 1976 · S/N E-890 N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568 N2138LBrooks John S · Camarillo, CAS/N E-893 N213CHEz Aviation LLC · Morrisville, NCS/N TH-2079 N213DBMarshall Air Systems Inc · Charlotte, NCBuilt 1993 · S/N BB-1450 N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247 N213JTLake Air Sale LLC · Wilmington, DEBuilt 2002 · S/N 525-0492 N213LAJet Rider LLC · Middletown, DEBuilt 2004 · S/N 208B1096 N213MCMcr Aviation LLC · Austin, TXBuilt 1991 · S/N FA-216 N213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486 N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073 N213SWSouthworth Aviation LLC · Memphis, TNBuilt 1996 · S/N 560-0363 N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N2141LErwin James Erskine III · Newnan, GABuilt 1976 · S/N E-896 N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855 N2144LPrivate Paws LLC · Colorado Springs, COBuilt 1976 · S/N E-895 N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778 N2148LL&M Cleared2land LLC · Coral Gables, FLBuilt 1976 · S/N E-897 N2149LRocky Hill Airshows Inc · San Jose, CABuilt 1976 · S/N E-898 N214AKAlaska Airlines Inc · Seatac, WABuilt 2019 · S/N 60579 N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670 N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350

Back to AD 2006-16-18 R1