AD 2012-11-08

Registered aircraft · 177

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:2012-11-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-08')
  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.

N53GLWaco Classic Aircraft Corp DBA · Battle Creek, MIBuilt 2015 · S/N 1206N53VCAbita Skies LLC · Robert, LAS/N 1009N543KThoensen Thomas R · Delta, COS/N 49N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828N5603LKushnir Borys G · Tamuning, GUBuilt 1974 · S/N 0702N5613LRed Rock Flyers LLC · Flagstaff, AZBuilt 1974 · S/N 0704N5761GNelson Ken · Caledonia, WIBuilt 1980 · S/N 0831N5761ZHannibal Aviation LLC · Stamford, CTBuilt 1980 · S/N 0834N5762BAssociated Aircraft LLC · San Diego, CABuilt 1980 · S/N 0833N5762DNavar Thomas R · El Paso, TXBuilt 1981 · S/N 1004N5762GBrown Patrick T Trustee · Osceola, WIBuilt 1981 · S/N 1003N5886LCook Charles N · Lakeside, TXBuilt 1975 · S/N 0707N5ZMDakota & Skyy LLC · Louisville, COBuilt 1975 · S/N 0722N6016LAssociated Aircraft LLC · San Diego, CABuilt 1975 · S/N 0710N6022LIrving Donald J · Deland, FLBuilt 1975 · S/N 0712N6036LCrestair Air LLC · Dover, DEBuilt 1975 · S/N 0713N6053LHenson Randolph C · Spring, TXFirst renewal noticeBuilt 1976 · S/N 0727N6054LTriple-R-Biplane Inc · Andover, NJBuilt 1975 · S/N 0715N6075LChandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 0716N60GLMiko Pawel Marcin · Santee, CABuilt 1978 · S/N 0806N6185LKanaster Larry D Trustee · Tacoma, WABuilt 1976 · S/N 0510N6196LFiala Frederick P · Kingwood, TXBuilt 1976 · S/N 0723N6197LRanger Airfield Foundation · Ranger, TXBuilt 1976 · S/N 0724N6199LBoddy Derrick M · Aiken, SCBuilt 1976 · S/N 0726N621GLOverwatch Tools Inc · Chesapeake, VABuilt 2022 · S/N 1217N6247LChandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 0733N6262LGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1976 · S/N 0734N647KHoover Michael B · Ridgeland, WIBuilt 1930 · S/N 111N648KNichols Charles F Trustee · Baldwin Park, CAS/N 183N703GLTimblin Joel R · Boyceville, WIS/N 0701N705KKelley Paul V Jr · Atlanta, GAFirst renewal noticeBuilt 1929 · S/N 52N707GLVoler Dans La Gloire LLC · Narberth, PABuilt 1976 · S/N 0729N707RMWilkes Jack M · Port Orchard, WABuilt 1976 · S/N 0737N711PTTaylor Stephen N · Punta Gorda, FLBuilt 1976 · S/N 0731N727KRRogers Ronald J · Crystal Lake, ILBuilt 2022 · S/N 1221N728GLMartin James D · Graford, TXBuilt 1976 · S/N 0728N748LLdz Aviation Resources LLC · Sayville, NYBuilt 1976 · S/N 0748N763GLUzyn Jerry J · Lafayette, INBuilt 1977 · S/N 0763N765GLCroll H Robert III · Jacksonville, ORS/N 0765N76GLSullivan Vincent E · Centerville, IABuilt 1976 · S/N 0736N771VYGarcia Pedro · Hudson, OHBuilt 1976 · S/N 0742N777PAce Aeromotive Inc · Miami, FLBuilt 1929 · S/N 128N780ZAGreat Lakes Belle LLC · Furlong, PABuilt 1975 · S/N 0718N789JFCoordinated Turn LLC · Fort Worth, TXBuilt 1976 · S/N 0745N78JRFocus Air LLC · Wilmington, DEBuilt 2020 · S/N 1214N791BKBoucher Robert Nc · The Plains, VABuilt 1978 · S/N 0798N799DBTreetop Flyer LLC · Crozet, VABuilt 1978 · S/N 0799N79GLJones Robert B · Fresno, CABuilt 1977 · S/N 0754N802GLGiles Forrest D · Springtown, TXS/N 0802N80AMGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1980 · S/N 0829
Back to AD 2012-11-08