AD 2006-10-21

Registered aircraft · 44,908

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
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-10-21')
    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-10-21')
  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.

N15694Registered aircraftBuilt 1972 · S/N 28-7305119N15695Baldwin Lydia H · Fort Collins, COBuilt 1972 · S/N 28-7305120N15696Truair LLC · Chaska, MNBuilt 1937 · S/N 1N1569XStroud Jerry L · Hope, ARS/N 28R-7535331N156AADardis Aviation LLC · Alpine, WYBuilt 2007 · S/N 2390N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751N156DMDeleonrdis Donato · Paulden, AZBuilt 2004 · S/N 18N156DSFanoe Nicholas J · Salinas, CABuilt 2000 · S/N 23064CN156HRCallahan Bryan J · Apalachicola, FLBuilt 2007 · S/N 156 KITN156LGAirsign Airships America LLC · Williston, FLBuilt 2000 · S/N 106N156MAMedia Exp LLC · Portland, ORBuilt 1997 · S/N 001N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435N156PSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.492N156RMMarek Robert C · Cadott, WIBuilt 2001 · S/N 019N156SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4159N156WMFixed Wing Holding Company Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496156N156XN156x LLC · Fayetteville, GABuilt 1978 · S/N 32-7840156N15703Schubert Brothers Aviation Inc · Canandaigua, NYFirst renewal noticeBuilt 1972 · S/N 28-7305125N15707Brennan Christopher S · Newark, DEBuilt 1972 · S/N 28-7310069N15708Lanza Thomas N · Las Vegas, NVBuilt 1972 · S/N 32-7340058N15709Avioelectronica Inc · Sunrise, FLS/N 34-7350088N1570RHall Clarence W Jr · Fayetteville, ARS/N M-1368N15725Hassell Dan J · Ketchikan, AKBuilt 1991 · S/N S1565N1572EKorkmaz Fethi A · Asheville, NCS/N 32-7340059N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072N15731Parsons Allen L · Marriottsville, MDBuilt 1972 · S/N 28-7305129N15734Wayland Flyboys LLC · Wayland, IABuilt 1972 · S/N 28-7305131N15735235 Aviation LLC · New Smyrna Beach, FLS/N 28-7310071N15739Flymart Inc · Hastings, FLS/N 28-7305132N1573RGrand Scott LLC · Okemos, MIBuilt 1975 · S/N AA5B-0073N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086N1574XQuinones Roland · Plano, TXS/N 28R-7535338N15757Dickinson Ross · Tilden, TXBuilt 1972 · S/N 28-7305137N1575RSpurlock Daniel C · Harrogate, TNS/N AA5B-0075N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064N1577ESeibert Lynn K · Fresno, CAS/N 1131N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026N15782Crane Austin · Redlands, CAS/N 28-7305144N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094N1579RSkelton James P Jr · Lithia Springs, GABuilt 1975 · S/N AA5B-0079N1579TPedro Christopher M · Dushore, PABuilt 1997 · S/N 5055N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111N157AMPhotofax Inc · Gilberts, ILFirst renewal noticeBuilt 2001 · S/N 2157
Back to AD 2006-10-21