AD 80-25-07 R1
Registered aircraft · 25,369
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-25-07-R1')
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-25-07-R1')
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-25-07-R1') 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-25-07-R1') 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.
N68536George Mattson Farms Inc · Chester, MTN68537Hanson David J · Elgin, TXN6853HJohnson Seth W · North Pole, AKN6853UHobson Davy R · Grapeland, TXN6853VReuland Aviation Services LLC · Marietta, GAN68540Frazee Zachary S · Meridian, IDN68541Britt Crop Care Inc · Indianola, MSN68543Waltemath Troy A · Augusta, KSN68544Small Kevin D · Dallas, TXN68545Klamar Spraying Inc · Gatzke, MNN68547Seley Ronald J · South Pasadena, CAN6854HN6854h LLC · Opa Locka, FLN6854NTeel Glen A · Hays, KSN6854UChristler Flying Svc Inc · Enumclaw, WAN6854VRegistered aircraftN68550Gembala Randall L · Kalispell, MTN68553Holmes David D · Spokane, WAN6855USebek Kenneth D · Guntersville, ALN6855VN6855v LLC · Madras, ORN68564Beck Donald W · Garrison, MTN68567Goldbach Charles H · Valleyford, WAN6856NTagle Robert J II · San Antonio, TXN6856VHudson Daryl J · Ukiah, CAN68570Chmiel John P · Wausau, WIN68572Precision Guided Solutions LLC · Sioux Falls, SDN68573Etherington Sara L · Belton, MON68574All Attitude Aviation Inc · Edgewater, FLN68575Kushner Herbert A · Bridgewater, NJN68576Robinson Neil A · Madison, WIN68579Schaefer Gerard P · Olive Branch, MSN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6857STailgate LLC · Felton, GAN6857UShabotynskyj Kathleen · Palm City, FLN6857VBerry Mark · Ellenboro, NCN6858HPrairie Skies Aviation LLC · Hutchinson, KSN6858NBarnes Kevin Lee · Greensboro, MDN6858UMattingly James P · Edwardsville, ILN6859HRoeper Gary Lee · Linden, MIN6859NLozar Dianne C · La Harpe, ILN6859UFischer John C · North Highlands, CAN685GTEatmb Air Inc Trustee · Wilmington, DEN685JWGiurtino Joel F · Spring Hill, FLN685SMKendrick Michael L · Rochester, MNN685TTwist Air Inc · Overland Park, KSN68608Oxford Aircraft Leasing LLC · Oxford, NCN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6861HViking Systems Inc · Naples, FLN6861NCooke Douglas L · Ventura, CAN6861VJ & B Aero Inc · Albuquerque, NMN6862HStrickland J A · Fairbanks, AK
Back to AD 80-25-07 R1