OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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-07-13')
    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-07-13')
  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.

N114MGW F Carter Construction Inc · Arlington, TXBuilt 1978 · S/N 14382N114MMSchwabenbauer Theodore J · Diamond Bar, CAS/N 14380N114MTSattig Henry B II · Cortez, COBuilt 1976 · S/N 14068N114PBBernabucci Christian J · Mapleton, NDBuilt 1976 · S/N 14057N114PMSundance Aviation · Morganton, NCBuilt 1999 · S/N 14666N114PWSiddiqu Shahid · Hampton, VAS/N 14542N114RCAsbury William A · Bridger, MTBuilt 1976 · S/N 14011N114RRMdb Air LLC · Poway, CABuilt 1996 · S/N 20015N114RWLaw C Scott · Oklahoma City, OKBuilt 1976 · S/N 14048N114SDPremier Property LLC · Elkin, NCS/N 14264N114SEHigh Flight Aviation LLC · Charlotte, NCS/N 14027N114SGMixon Christopher L · Lafayette, LABuilt 1979 · S/N 14535N114SJMeashey Matthew · Wake Forest, NCBuilt 1977 · S/N 14318N114SLSimply Living LLC · Fort Myers, FLS/N 122N114SMColvin Daniel A · Dayton, TNBuilt 1978 · S/N 14442N114SRSkymaster Stc LLC · Mena, ARS/N 14016N114SSHeritage Air LLC · Scappoose, ORS/N 14291N114TBWelch D Michael · Foster City, CABuilt 1976 · S/N 14172N114TCIntegritas Forum LLC · Sundance, WYBuilt 1978 · S/N 14355N114USPeters Richard A · San Marino, CABuilt 1978 · S/N 14386N114VCStevenson Andy · Boyd, TXBuilt 1993 · S/N 14581N114WCMahan Dusty · Cookeville, TNBuilt 1976 · S/N 14126N114WEL & K Aviation Holdings LLC · Leavenworth, KSS/N 14540N1151JRescue Evangelical Church · Fitchburg, MABuilt 1974 · S/N 151N1156JTeam Omega Multimedia Ohio LLC · Blacklick, OHBuilt 1974 · S/N 156N115CEDentate Equipment Leasing LLC · Belmont, MABuilt 1999 · S/N 14667N115GTWahl John H · Rockwell City, IAS/N 20042N115JWFeric Drazen · Mesa, AZBuilt 1976 · S/N 14081N115KTMulva Jonathan · De Pere, WIBuilt 2002 · S/N 20044N115MDSpecial Orthogonal Group LLC · Dover, DEBuilt 2001 · S/N 20039N115SJWolf Richard · Yerington, NVBuilt 1994 · S/N 14614N115SZThree Greens LLC · San Jose, CABuilt 2000 · S/N 20036N1160JSchreiber William E II · Edgar, WIBuilt 1973 · S/N 125N1161JMnd Services LLC · Joliet, ILBuilt 1974 · S/N 161N1163JBottom Line Aviation LLC · Scranton, NDS/N 163N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061N116SB114b Holding Inc Trustee · Wilmington, DEBuilt 2000 · S/N 14678N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N1180JVegas Alex · Leesburg, VAS/N 149N1181JWinston James Eldon Jr · Granbury, TXBuilt 1974 · S/N 181N1182JAndrew Kenneth S · Dawson, GABuilt 1974 · S/N 155N1185JBirk Ronald G · Wellington, NVBuilt 1974 · S/N 178N1189JCollom David M · Lockport, ILBuilt 1974 · S/N 189N1190JSeignious Russell V · Pass Christian, MSBuilt 1974 · S/N 190N1191JMag-Nif Inc · Mentor, OHBuilt 1974 · S/N 234N1193JFloyd Michael E · Tulsa, OKS/N 185N1194JSmith Jerry L · Newport News, VAS/N 194N1195JRickard Trucking Inc · Eddyville, KYBuilt 1974 · S/N 195
Back to AD 2011-07-13