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.

N16361Fly 361 LLC · Doswell, VABuilt 1973 · S/N 28R-7335134N16362Flightline Air Service LLC · Pineville, LABuilt 1973 · S/N 28R-7335135N16363Bloemker Edward L · Fremont, NEBuilt 1973 · S/N 28-7310090N16367Swartzbacker Paul · New Lenox, ILBuilt 1973 · S/N 28-7305237N16368Tougas William E · Timberlake, NCBuilt 1973 · S/N 28R-7335136N1636BOlson Lance E · Hillsboro, ORBuilt 1999 · S/N 2700N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228N16371Melendy Corey Wayne · Enid, OKBuilt 1973 · S/N 28-7310091N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083N16374Milliard Craig R · Benicia, CABuilt 1973 · S/N 28-7305238N16377Jones Aaron M · Conrad, MTBuilt 1973 · S/N 28-7310092N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026N16385Haines Michael C · Wadsworth, OHBuilt 1973 · S/N 28-7305242N16387Anderson Jeffrey J · Hartland, WIBuilt 1973 · S/N 28-7310093N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027N16398Withers Harry R · Beaufort, SCBuilt 1973 · S/N 28-7305244N163AMRogers Brian D · Pacific, MOBuilt 1968 · S/N 28-5009N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163N163BDPlanenutts LLC · Tulsa, OKBuilt 1991 · S/N 1N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715N163MABlue Dawg LLC · Sandpoint, IDBuilt 2005 · S/N 2303N163MMJ & L Avstar Corp · Paducah, KYBuilt 1993 · S/N 27-0163N163RKGardner Michael John · Ashland, ILBuilt 2006 · S/N 11120N163SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4175N16402Peters Dale M · Naknek, AKBuilt 1973 · S/N 28-7305245N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221N16412Cherokee N16412 LLC · Peoria, AZBuilt 1973 · S/N 28-7305247N16415United Aviation LLC · Prospect, KYS/N 32-7340085N16417Riddle Christopher Joseph · Auburn, CABuilt 1973 · S/N 28-7305249N16418Hallgren Mitchel T · Sycamore, ILBuilt 1973 · S/N 28-7305250N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145N16425Box Aviation Inc · Montgomery, ALBuilt 1973 · S/N 28-7305251N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112N1643Elias Bernard J · Hampton, GABuilt 1982 · S/N 3008N16430Lyons Larry A · Stockton, ILBuilt 1973 · S/N 28-7305252N16435Gumms Leroy J · Perris, CAS/N 28-7305254N16437Novawings Aviation LLC · Porter, TXS/N 28R-7335146N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754N1643HSiegenthaler Dean · Mineral Point, WIBuilt 1977 · S/N 32-7700011N16440Bolen Darin L · Murfreesboro, TNBuilt 1973 · S/N 28-7310097N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087N16448Lynch Timothy Christopher · Robbinsville, NJBuilt 1973 · S/N 28-7305256N16449Cloud Nine Flying Club Inc · Fergus Falls, MNBuilt 1973 · S/N 28-7305257N16456Blackwell Jerry R · Jackson, TNBuilt 1973 · S/N 28-7305260
Back to AD 2006-10-21