AD 2011-02-08

Registered aircraft · 83

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:2011-02-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:2011-02-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.

N394BACivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 019002N400AZCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998702N403BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029017N410BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029005N419BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029006N41BWCentral Ms Soaring Society LLC · Brandon, MSS/N 917921N420BACivil Air Patrol · Maxwell Afb, ALS/N 029007N426BACivil Air Patrol · Maxwell Afb, ALS/N 029008N427BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029009N428BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029010N430BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029012N431BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029013N433BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029014N434BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029011N437BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029015N438BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029016N443BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2002 · S/N 029018N455BASoaring Club Of Houston · Waller, TXBuilt 2003 · S/N 039020N470BACivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 069204N5537Wright Wayne M · Chestertown, MDBuilt 1992 · S/N 928003N6289White Sands Soaring Association Inc · Alamogordo, NMS/N 938104N8023N305mg LLC · Homestead, FLBuilt 1993 · S/N 938023N802SSierra Soaring Club · Ridgecrest, CABuilt 1992 · S/N 928002N806SFun Country Soaring Inc · Valley City, OHFirst renewal noticeBuilt 1993 · S/N 928006N809SPiedmont Soaring Society · Winston Salem, NCBuilt 1992 · S/N 928009N816SSeminole Flying & Soaring Inc · Clermont, FLBuilt 1993 · S/N 938016N830SBHigh Flights Soaring Club · Peyton, COBuilt 1993 · S/N 938030N911HGunnarsson Jon · Concrete, WABuilt 1991 · S/N 917911N912BBrokenstraw Flyers · Pittsfield, PABuilt 1992 · S/N 917912N914BPuget Sound Soaring Association · Enumclaw, WAFirst renewal noticeBuilt 1992 · S/N 917914N915SBTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1991 · S/N 917915N922SBWillamette Valley Soaring Club Inc · Cornelius, ORBuilt 1991 · S/N 917922N979ASSteamboat Springs Soaring Association Inc · Steamboat Springs, COS/N 948126
Back to AD 2011-02-08