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.

N520CAGruia Alin · Beaverton, ORBuilt 1977 · S/N 13187N526AWRegistration Pending · Shell Lake, WIRegistration pendingBuilt 1977 · S/N 14226N527GTSchellhase Walter S · Kerrville, TXBuilt 1980 · S/N 14528N529VMCgm Aviation LLC · Gainesville, FLBuilt 1993 · S/N 14582N535CAHanson Robert M · Riverside, CABuilt 1977 · S/N 14293N5424DCarpenter Michael H · Mooresville, NCS/N 20028N54RRValentin Jose E · Murrieta, CABuilt 1976 · S/N 13107N555LPAerodyme Corp · South Burlington, VTBuilt 1978 · S/N 14405N555SSSkylink Group LLC · York, PABuilt 1976 · S/N 14045N558EAerodyme Corp · South Burlington, VTS/N 14603N56CVVaughn Geoffrey · Brunswick, GABuilt 1976 · S/N 14017N5796NClausing Howard · Menomonie, WIBuilt 1978 · S/N 14369N579CAMcnamer Martin J · Dubuque, IABuilt 1993 · S/N 14579N57BHBester Eric M · Shelby, NCBuilt 1976 · S/N 14001N5804NAvioneta LLC · Atwater, OHBuilt 1978 · S/N 14372N5805NRmz Aviation LLC · Cartersville, GAS/N 14373N5809NN5809n Inc · New Castle, DES/N 14376N5832NWitherington III William A · Newnan, GABuilt 1978 · S/N 14381N583GWGentlemans Investments LLC · Camden, MEBuilt 1978 · S/N 14387N5842NAero Florida LLC · Geneva, FLBuilt 1978 · S/N 14390N584CALance Toland Ltd · Griffin, GABuilt 1993 · S/N 14584N5854NShort Brian D · Rock Island, ILBuilt 1978 · S/N 14399N5859NPegasus Flight LLC · Carbondale, ILS/N 14404N585CAThomas-Guy Ltd · Newtown, PABuilt 1993 · S/N 14586N5861NTyler Christopher G · Olympia, WABuilt 1978 · S/N 14406N5871NBraun Janet M · Pocono Pines, PABuilt 1978 · S/N 14416N5872NMeans Loren Alonzo III · Wasilla, AKBuilt 1978 · S/N 14417N5877NMeisner Shane · Fredericksburg, VABuilt 1978 · S/N 14422N5879NBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 14424N5887NBerkshire Commander Air LLC · Pittsfield, MABuilt 1978 · S/N 14502N5890NSmith William Leonard · College Station, TXBuilt 1979 · S/N 14504N5893NKoehn Juergen A · Lago Vista, TXBuilt 1979 · S/N 14506N5895NCommander Club LLC · Hudson, WIBuilt 1979 · S/N 14508N5900NMackin Marvin L · Merced, CABuilt 1979 · S/N 14513N5903NMotte Larry P · La Porte, TXBuilt 1979 · S/N 14520N5909NN5909 LLC · Hypoluxo, FLS/N 14526N5917NHunsaker James M · Canby, ORBuilt 1979 · S/N 14534N595TCExecutive Outcomes Pc · Jackson, TNBuilt 1995 · S/N 20005N5WPPhagan Loyce W · Waterford, MIBuilt 1973 · S/N 92N60046Lee John C · Marietta, OHBuilt 1992 · S/N 14546N6007HPolice Facility Design Group Pa · Kansas City, KSBuilt 1993 · S/N 14593N6007ZSharkey John F III · Oswego, NYBuilt 1992 · S/N 14555N60096Barto Jerrel · Kula, HIBuilt 1992 · S/N 14552N6010YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 14589N6023AKirkendall Shane O · Cedar Park, TXBuilt 1993 · S/N 14604N6024NRegistered aircraftS/N 14605N6024PJohn D Holderman · Sarasota, FLBuilt 1993 · S/N 14608N6029BSchmidt Glenn J · Wesley Chapel, FLBuilt 1994 · S/N 14613N6033A3v Global LLC · Clermont, GABuilt 1994 · S/N 14616N6033GViking Ball LLC · Wilmington, DEBuilt 1994 · S/N 14617
Back to AD 2011-07-13