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.
N5599QFerraro Christopher · Croydon, PAN559BCEllison James Carl · Norman, OKN559TTMcdonald Aviation Mgt LLC · San Jose, CAN55AMAdams Floyd R · Sebring, FLN55DHAcmed Consulting LLC · Bradford, RIN55DZHuey Christopher D · Mesa, AZN55EUC L Holdings LLC · Washington, DCN55FFSiedschlag Paul C · Granbury, TXN55GASaathoff Michael A · Stockton, MON55HAHonaker Group LLC · Sellersburg, INN55HQHerndon Colton R · Smithville, MON55JJPrivitt Bret · Fort Worth, TXN55KHDietle Kurt · Valley Springs, CAN55KRBaird Keith W · Marianna, FLN55LGWard Randy · Port Saint Lucie, FLN55LLCosmo Air LLC · Dayton, OHN55MPCommanche LLC · Slatington, PAN55NPN55np LLC · Broomfield, CON55PGGonzalez Pota H · Seguin, TXN55QBSainthill Raymond C · Long Beach, NYN55RXJs Enterprises LLC · Clarinda, IAN55SFRegistered aircraftN55VMSpurr Richard R · Bloomfield, NYN55WMBankston Jeffery · Rice, TXN55YPBmf Jax LLC · Jacksonville, FLN5600QA & D Aviation LLC · Aberdeen, OHN5601QRegistered aircraftN56027Pitler Joshua · Oklahoma City, OKN5602QWacker Jeremy C · Denver, CON56035Schindler Nick E · Neligh, NEN5603LKushnir Borys G · Tamuning, GUN5604QSkywagons.Com LLC · Placerville, CAN5605JMajor Air LLC · Charleston, SCN5605QBennett Steven D · La Fayette, GAN5608YVan Laere Jeffrey John · Ferndale, MIN560MBCorrigan Patrick · Hondo, TXN560PCHillsboro Aero Academy LLC · Hillsboro, ORN560ZHeslin Jon P · Sutton, MAN56100Des Moines Flying Club LLC · Indianola, IAN5610QRustad Scott K · Minot, NDN5611QSale Reported · Star Prairie, WISale reportedN5612DMastiff Aviation LLC · Fairbanks, LAN5612QSrm Aviation Group LLC · Bentonville, ARN5613LRed Rock Flyers LLC · Flagstaff, AZN5613QLysek Eric M · Erie, CON5614QAltitude Aviation Services LLC · Mountain Home, IDN5615QKhan Awad A · Clearwater, FLN5616EDhl Skyhawk Inc · Martinez, CAN5617JSale Reported · Wilton, CASale reportedN5617QRegistration Pending · Perryton, TXRegistration pending
Back to AD 80-25-07 R1