AD 96-10-13
Registered aircraft · 176
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:96-10-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:96-10-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.
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:96-10-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:96-10-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N302TAMidwest Flying Service LLC · Wilmington, DEN303TSCheyenne Air LLC · Ocean City, NJN30DUHtf Aviation LLC · Kalispell, MTN321FUTms Turboprop 2xl LLC · Wilmington, DEN321LBSpeer Transport LLC · El Cajon, CAN324ARParrish Blake · Seminole, TXN328RED & R Ezzell Inc · Rockwall, TXN329KKBristol Aircraft Leasing LLC · Montgomery, ALN333XXArnot Robert · Stowe, VTN336PN336p LLC · Williamstown, NJN34HM71wg LLC · Tulsa, OKN37PJDodson International Parts Inc · Rantoul, KSN38TWPlanemarketing LLC · Vero Beach, FLN390JDSevern Aeronautics Ltd · Annapolis, MDN390JPLucky7 Air LLC · Lenoir, NCN396JHGoode Todd · Nampa, IDN398SPHillcrest Aviation LLC · Clear Lake, IAN39EHAir Travel Management Of Delaware LLC · Wilmington, DEN39TLDunamis Resources LLC · Lewes, DEN3RKCorinthian LLC · Southgate, MIN400CMAerial Surveys International LLC · Watkins, CON400WSHatbright Farm LLC · Wilmington, DEN401VAPro Aire Cargo & Consulting Inc · Oshkosh, WIN403MCorporate Aircraft Group LLC · Annapolis, MDN406RSAero South Florida Inc · Deerfield Beach, FLN40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNN410CAJustifications LLC · Wilmington, DEN427DDYunus Asim · Saginaw, MIN427TAAircraft Properties LLC · Hampstead, NCN43WHLaurel Malibu LLC · Windber, PAN444PCValiair Limited Company Trustee · Casper, WYN444RCTiffin Aire Inc · Tiffin, OHN444WGSchmucker Real Estate Holdings Lp · Wilmington, DEN454CACul8tr LLC · Boynton Beach, FLN455MMMiklus Enterprises LLC · Middletown, DEN473GGTiffin Aire Inc · Tiffin, OHN47JFReeve Howard E · Minot, NDN481SWFour Hills LLC - Piper Series · Plano, TXN4938SAviation Trust Co LLC Trustee · Oklahoma City, OKN497WWWin Win Aviation Inc · Wake Forest, NCN511PJNanavati Parashar Jayendra Trustee · Springfield, ILN515GAFramalin Leonard · Troy, MIN521JMJmcy Air LLC · Wilmington, DEN521PMJetset Airmotive Inc · Hialeah, FLN523PDRulewiez Dennis G · Jackson, MIN524AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN525SWKramme Scott R · Elmer, NJN528CHWord Jon D · Albuquerque, NMN52HLBaker Mark · Murfreesboro, TNN52TTMinuteman Aviation Inc · Missoula, MT
Back to AD 96-10-13