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.
N2585FDobberfuhl James P · Clinton, WAN2585WClassic Mooney Nv LLC · Henderson, NVN25860Sorbi Aviation Inc · El Cajon, CAN2586AInternational Air Services Inc Trustee · Carson City, NVN2586BAnderson Miles D · Reno, NVN2586DStay-Air-Borne LLC · Locust Grove, GAN2586FLofstrom Caleb J · Wasilla, AKN2586GJeppesen Thomas L · Stanton, MIN2586WVizinat David C · Ragley, LAN2586ZFernandez John III · Cape Canaveral, FLN2587CRegistration Pending · Kalispell, MTRegistration pendingN2587DLindee Thomas W · Minnetonka, MNN2587FPutt Putt Pilots LLC · Xenia, OHN2587NExecutive Air Leasing Inc · Minneapolis, MNN2587WOrourke Timothy L · Laguna Niguel, CAN2588DThurmond Georgette E · Palmdale, CAN2588WJohnson Mitchell R · Bismarck, NDN25890Henry Mark A · Dickinson, TXN25895Registered aircraftN25899Ace Aircraft Leasing Inc · Nazareth, PAN2589BOsterman Jeremiah E · Sautee, GAN2589WHart Christian L · Highland Village, TXN258BWEastern Kentucky University · Richmond, KYN258ERLewis Carlos Brandon · Indian Mound, TNN258JTWilson Cecil · Lithonia, GAN258KCBredesen Benjamin C · Nashville, TNN258MAJ Linn Aviation Inc · Quinlan, TXN258RAReynolds Darryl G · Wills Point, TXN25907Bishop Kenneth P · Griffin, GAN2590CKelley Judson R · Olympia, WAN2590GAnywhere Atp LLC · Mt Juliet, TNN2590WWheeler James N · Shreveport, LAN2590ZWollaston Dean E · Hazel Green, WIN25914Aces High Aviation LLC · Long Beach, CAN25918Wichita Area Technical College · Wichita, KSN2591GRivero Mark A · Henderson, NVN2591VLivewire Holdings LLC · Salinas, CAN25922Byrd-Pettit Caroline A · Smithfield, NCN25929Trevisan Hugo S · Polk City, FLN2592FDunlap Burton D · Mooresville, NCN2592LLondke Kevin S · Lexington Park, MDN25932California In Nice Inc · San Jose, CAN2593WUehlin Bradley S · Danbury, NEN25948Indiana State University · Terre Haute, INN2594GRuddle Kaleb T · Lawrenceburg, TNN2594NDivinity Enterprises LLC · Wilmington, DEN2594WMcclure Richard A · Victoria, TXN25950Gist Phillip C · Fort Worth, TXN25959South Texas Air Force LLC · Mission, TXN2595FDowell Grant A · Lansing, MI
Back to AD 80-25-07 R1