AD 80-01-08
Registered aircraft · 150
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:80-01-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:80-01-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.
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:80-01-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:80-01-08') 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.
N34HM71wg LLC · Tulsa, OKN37PJDodson International Parts Inc · Rantoul, KSN38TWPlanemarketing LLC · Vero Beach, FLN390JDSevern Aeronautics Ltd · Annapolis, MDN396JHGoode Todd · Nampa, IDN398SPHillcrest Aviation LLC · Clear Lake, IAN39EHAir Travel Management Of Delaware LLC · Wilmington, DEN39TLDunamis Resources LLC · Lewes, DEN400CMAerial Surveys International LLC · Watkins, CON403MCorporate Aircraft Group LLC · Annapolis, MDN406RSAero South Florida Inc · Deerfield Beach, FLN40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNN427DDYunus Asim · Saginaw, MIN427TAAircraft Properties LLC · Hampstead, NCN43WHLaurel Malibu LLC · Windber, PAN444PCValiair Limited Company Trustee · Casper, WYN444RCTiffin Aire Inc · Tiffin, OHN454CACul8tr LLC · Boynton Beach, FLN455MMMiklus Enterprises LLC · Middletown, DEN473GGTiffin Aire Inc · Tiffin, OHN47JFReeve Howard E · Minot, NDN481SWFour Hills LLC - Piper Series · Plano, TXN497WWWin 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, MTN53MCGulf Air Aviation Inc · Wilmington, DEN53TAIndiana Paging Network Inc · La Porte, INN545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555FRWallace Jeffrey S · Bonita Springs, FLN55RPneuma Aviation LLC · New Orleans, LAN59EHSale Reported · Dawsonville, GASale reported, pending cancellationN5DValiair Ltd Co Trustee · Casper, WYN601AJShamrock Aviation LLC · Madison, MSN606DWElkhorn Valley Trucks II LLC · Fremont, NEN60JWTumbleweed Leasing LLC · Tacoma, WAN6107AR & R Aviation Support LLC · Atlanta, GAN6175ATiffin Aire Inc · Tiffin, OHN620DBAlco Plane Co LLC · Memphis, TNN621AKPlane Fun Inc Tr Trustee · Snellville, GAN65BATts Leasing Inc · Kansas City, KSN66TWRolfe Bangerter Aviation LLC · Murray, UTN67DWDodson International Parts Inc · Rantoul, KS
Back to AD 80-01-08