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.

N246AAAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB984 N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412 N246CKMccarty David M · Baker City, ORBuilt 1976 · S/N LJ694 N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065 N246ESFlight Services Inc · St Thomas, VIBuilt 2023 · S/N 525-1161 N246GLBonanza Management LLC · Newark, DEBuilt 2001 · S/N 525-0446 N246GTWestern Pilot Service Inc · Phoenix, AZBuilt 2000 · S/N LJ-1591 N246PHPhi Health LLC · Tempe, AZBuilt 1990 · S/N BB-1373 N24702United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28763 N24706United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28767 N24715United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28786 N2472Vivid Aviation LLC · Las Vegas, NVBuilt 1976 · S/N E-906 N24729United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28945 N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254 N24736United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28803 N247AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36364 N247CHShe Jane LLC · Laguna Beach, CABuilt 2016 · S/N FL-1042 N247DGN247dg LLC · Lawton, OKBuilt 1990 · S/N 560-0082 N247FJConquest II LLC · Kenner, LABuilt 2008 · S/N 560-0782 N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247 N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720 N247JPSpirit Air Inc · Salmon, IDBuilt 2013 · S/N 208B5047 N247MDLta Group Holdings LLC · Amarillo, TXBuilt 1990 · S/N LJ1244 N247SZSheetz Aviation Inc · Altoona, PABuilt 2016 · S/N FL-1056 N248AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 62469 N248BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5796 N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368 N248EXUnited States Navy · Patuxent River, MDS/N FL-450 N248JHExecutive King Air Transportation Inc · Wilmington, DEBuilt 1982 · S/N BE-126 N248KAKamaka Air LLC · Honolulu, HIBuilt 2012 · S/N 208B2408 N248PAPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1988 · S/N 208B0134 N248PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N BB-1618 N2492YBenham Charles D · San Angelo, TXBuilt 1968 · S/N E-74 N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309 N249CALafayette Flight Service LLC · Broussard, LABuilt 1998 · S/N 525-0291 N249CCCianbro Corp · Pittsfield, MES/N 208B5094 N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841 N249TGHoot Aero LLC · Baton Rouge, LABuilt 2015 · S/N 20800579 N249WM249 Aviation LLC · Richland, MSBuilt 1975 · S/N LW-139 N24AWalker John D · Neosho, MOBuilt 1976 · S/N LW-210 N24ASRegistered aircraftBuilt 1985 · S/N E-2259 N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540 N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736 N24BGVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N BB-1045 N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145 N24DPEncore Cb4 LLC · Aventura, FLBuilt 2006 · S/N 560-0703 N24EMAsphalt Aviation LLC · Conway, SCBuilt 1976 · S/N BE-6 N24GBSmith Loren · Great Falls, MTS/N 421C0287 N24GFT & T Aircraft Holdings LLC · North Salt Lake, UTBuilt 2003 · S/N 560-0639 N24GNGlobal Air Concepts LLC · Anchorage, AKBuilt 1981 · S/N BB-953

Back to AD 2006-16-18 R1