AD 80-25-07 R1
Registered aircraft · 25,370
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.
N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKN267RAReynolds Darryl G · Wills Point, TXN267WSErvin Andrew · Centennial, CON2680WNielson Michael James · Spanish Fork, UTN2680ZEaston Christopher J · Burlington, MAN2681WAb Mooney LLC · Durham, NCN2681ZOchsenbauer Thomas G · Forest Lake, MNN2682ZEmslie Donis A · West Lafayette, OHN2683CGrigg Charles G · Pasco, WAN2683VPeters Robert M · Fremont, INN2683WSabagh Steve B · Maricopa, AZN2683ZAmmlim LLC · Vacaville, CAN2684GBlair Daniel S · Perrysburg, OHN2687ZSchaefer Richard T · Marble Falls, TXN2688VHampel Michael J · Camas, WAN2689JFinley Taylor J · Colby, KSN2689WLocke Timothy S · Fort Irwin, CAN268BHJett Cory L · Floyds Knobs, INN268ESHigh End Computing Systems Inc · Summit, NJN268JCShaw Melvin · Annapolis, MDN268JGSpero Bruce A · Carson City, NVN2690CEdwards Zachary · Sylmar, CAN2690JDodson International Parts Inc · Rantoul, KSN2690QSilva Alberto · Titusville, FLN2691VHanlon James Bradley Trustee · Fallbrook, CAN2692CStewart Chalmous · New London, NCN2692VKlr Aircraft Sales LLC · Wilmington, DEN2693ZCoen Brady · Wiley, CON2694WDickerson Steven Micheal · Tipp City, OHN2695ZJark David L · Stratford, SDN2696CUnited States Air Force · Peterson Afb, CON2696GGrabeman Allan · Fishers, INN2696WButler Collin · Danvers, MAN2696ZAdriatic Holdings LLC · Cheyenne, WYN2698WLivesay Wallace · Friendswood, TXN2699WKingman Connor Joseph · Lemoore, CAN269ACBurks Aviation Inc · Hattiesburg, MSN269BJN2893e LLC · Reno, NVN269CJLarson Martin B · Rapid City, SDN269MAOrange Wing Aviation Inc · Wilmington, DEN269NEOro LLC · Tilden, NEN269PBHmw LLC · La Grange, NCN26BYSnohoacro LLC · Mukilteo, WAN26CARogers Patricia A · Albany, ORN26CWBarzelatto Brett · Thornton, CON26EFMischel Herbert · Las Vegas, NVN26FPTate Zachary W · Cypress, TXN26HSCole Gregory B DBA · Santa Cruz, CAN26KNSky King Aviation Inc · Weslaco, TXN26MF2nd Amendment Consulting And Design LLC · Red Bluff, CA
Back to AD 80-25-07 R1