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.

N2177FSchofield William R · Fort Mill, SCBuilt 1979 · S/N 28-7911097N2177JPlane Skies Aviation · Cedar, MNBuilt 2000 · S/N 27-0286N2177QKovarik Lucas M · Ord, NES/N 18281347N2177TRegistration Pending · Pine Mountain, GARegistration pending, pending cancellationBuilt 1971 · S/N 28-7205032N2177ZRegistration Pending · Fayetteville, NCRegistration pendingBuilt 1979 · S/N 28-7911154N2178CHowey Paul W · Stevensville, MDBuilt 1978 · S/N 17702748N2178SAbbey Alyssa · Novato, CABuilt 1979 · S/N R18201310N2178TOrban John J · Dewitt, MIBuilt 1971 · S/N 28-7205035N2178WCarrillo Salvador Arias · Lompoc, CABuilt 1974 · S/N M-1522N2178YN2178y LLC · Cumming, GABuilt 1979 · S/N 28-7990381N2178ZMaloskey Scott M · Marion, IABuilt 1979 · S/N 28-7911156N21796Seegmiller Geoffrey · Houston, TXBuilt 2004 · S/N T18208329N2179MKairez Carolyn E · Punta Gorda, FLBuilt 2005 · S/N T18208466N2179TKroeger William R · Plattsmouth, NEBuilt 1972 · S/N 28-7205024N2179UFlorea Byron · Carencro, LABuilt 1963 · S/N 341N2179ZHill Robert · Anaheim, CABuilt 1979 · S/N 28-7911157N217BWAuer William E · East Liverpool, OHBuilt 2005 · S/N 81217N217DKHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2018 · S/N 2556N217DLValiair Lc Trustee · Casper, WYS/N T20608224N217EPEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2017 · S/N 172S12006N217LFSnyder Aero LLC · Joshua, TXBuilt 1969 · S/N 32-1157N217LSCole Spur Aviation LLC · Gould, ARBuilt 2016 · S/N 3256N217PFBixenman Kenneth J · Colby, KSBuilt 1997 · S/N 784-97N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144N217TXLong Jeffrey E · Dothan, ALBuilt 1997 · S/N 3246070N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060N2180FGentle Breezes LLC · Johnson City, TNBuilt 1978 · S/N 32-7940012N2180KRoad Runner Flying Club Inc · Radcliffe, IABuilt 1978 · S/N 28-7911082N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027N2180WGerges Amir · Arlington, TXS/N M-1563N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383N2180ZM&M Aero LLC · Wilmington, DEBuilt 1979 · S/N 32-7940102N2181AL&C Ventures LLC · Clovis, NMBuilt 2005 · S/N T18208467N2181NState Of Oregon · Salem, ORBuilt 2004 · S/N 18281339N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124N2182CSkyhunter LLC · Yonkers, NYS/N 17702749N2182FKleen Sheen IV LLC · Bowling Green, KYBuilt 2004 · S/N 18281340N2182KDura Built LLC · Greensburg, KYBuilt 2005 · S/N T18208469N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297N2182SCimprich Michael J · Kirkland, WABuilt 1979 · S/N R18201311N2182VJavorsek Daniel II · Harriman, TNS/N 32R-7987117N21836C & S Development Services LLC · Weatherford, TXBuilt 1978 · S/N 32R-7885263N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163N2183JMichael Nehring Inc · Mohall, NDBuilt 2004 · S/N 172S9631N2183KMaven Aviation LLC · Dillon, MTBuilt 1978 · S/N 32-7940022
Back to AD 2006-10-21