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.
N6031QWhittier Frank · Las Vegas, NVN6032RMatecumbe Flying Service Inc · Immokalee, FLN6033QHerfield Colton · Lawton, OKN6034QBas Part Sales LLC · Greeley, CON6035QWylie Warren J · Montague, NJN6036LCrestair Air LLC · Dover, DEN6039QEagar Mark A · Cameron Park, CAN6041QDonohue Mark A · Red Lodge, MTN6042QMacfie Andrew · Richmond, CAN6044QOliver Nicholas R · Arroyo Grande, CAN6046QRed Desert Aviation LLC · Hurricane, UTN6048GWitthuhn Johnie B · Callaway, NEN6049QBudgett Stephen A · Gilbert, AZN6051EMathews James L · Menlo Park, CAN6051QWhite Jeffrey M · Carlsbad, CAN6052QCash Alan B · Fort Worth, TXN6053LHenson Randolph C · Spring, TXFirst renewal noticeN6054LTriple-R-Biplane Inc · Andover, NJN6055QGlenn Howard Anderson Jr · Wakefield, RIN6056CFlight Contract Services Inc · Las Vegas, NVN6057QKennedy Kyle R · Berrien Springs, MIN6059QSchoenleben Thomas J · Stevensville, MTN605JTKiefer Matthew J · Xenia, OHN6061QThurston David H · Cincinnati, OHN6063ELawrence Aviation LLC · Overland Park, KSN6063QTaylor Alan M · Nekoosa, WIN6064QWilliams Rodney K · Stacy, MNN6065QShick Douglas Todd · Chester, VAN6066QArmagost James C · Belton, TXN6067QFrantz Joseph M · Gill, CON6068QPressley Jerry · Morristown, TNN6069PAirborne Helicopters LLC · Hendrum, MNN606GSHillsboro Aero Academy LLC · Hillsboro, ORN606RWInternational Air Services Inc Trustee · Carson City, NVN606WLarson Bernard J · Mt Vernon, WAN6070QOdenbach Eric J · Eureka, SDN6071QHaven Hospitatlity LLC · San Marino, CAN6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CAN6074QMiranda Edward G · Prescott Valley, AZN6075LChandler Air Service Inc · Chandler, AZN6078CKtoa Rentals LLC · Torrance, CAN6079CAllen William H Trustee · Big Bear City, CAN6081CShannon Jeanette M · Marathon, FLN6082QIrvine Brooklyn L · Sacramento, CAN6083JB&R Aircraft LLC · Wadsworth, OHN6083QAjirogi Michael T · Pearl City, HIN6083VScholz Francis M · Atchison, KSN6084MGrider Charles H III · Belleville, ILN6084QHammond Edward M · Grass Valley, CAN6085MWood Mark D Trustee · New Berlin, WI
Back to AD 80-25-07 R1