AD 80-10-01
Registered aircraft · 2,613
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-10-01')
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-10-01')
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-10-01') 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-10-01') 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.
N112SSOlsen John · Wasilla, AKN113BHBighorn Airways Inc · Sheridan, WYN113LCLcd Aviation Corp · Wilmington, DEN113TBBeaudoin Todd · Castleton, NYN1145FGurke George J · Anchorage, AKN115AWMillican Marc J · Anchorage, AKN11669Cummings Arthur · Delta Junction, AKN1169QRohde Allen G · Eagle River, AKN116AKLucas Kelly W · Wasilla, AKN1177SRoss Robert S · Pigeon, MIN1185Wahlers Richard H · Meridian, IDN1185TBelanger Ernest E · Wasilla, AKN118ARegistration Pending · Shasta, CARegistration pendingN118RABroken Aero Inc · Dunnellon, FLN1197FSchumacher Bradley M · Lewiston, IDN119DSDeltasierra LLC · Staunton, VAN119WCSmith Steven W · Kodiak, AKN11ATChan Roger J · Anchorage, AKN11CSilicz Nicholas J · Shafter, CAN11CEMelcher Pierre S · New Braunfels, TXN11HHRegistration Pending · Durango, CORegistration pendingN1204FMoroney Aviation LLC · Chugiak, AKN1206FHarrah Daniel R · Juneau, AKN1208FYukon Air Service Inc · Fairbanks, AKN1211FGarner Greg A · Renton, WAN1217FUnited States Department Of Interior · Boise, IDN121EESheldon Air Service LLC · Anchorage, AKN121KSCa-C180j LLC · Addison, TXN121RDVickery Forest H · Tallahassee, FLN1222FVelocity Sport LLC · Cedar Falls, IAN1225QDupont Larry W · North Hero, VTN1227FPeterson Investments Inc · Polson, MTN122VCTurner Terrance A · Anchorage, AKN1231FRegistration Pending · Wasilla, AKRegistration pendingN1232FLloyd Land Plane I LLC · Brighton, CON1234YDe Jong Thomas · Buckeye, AZN1236FPitcher Michael C · Mancelona, MIN1237Fraser Mark L · Fairfield, CAN1239FValpey R Wesley Jr · Medford, MEN123EPFalkenberg Randy J · Edmonson, TXN123LJRegistered aircraftN124LRWilson David J · Palmer, AKN124UAKagerer John A Trustee · Anchorage, AKN1250WScherff Lewis H Trustee · Inver Grove, MNN1251BJagow Charles Philip · Fairbanks, AKN1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKN12580White River Ag Spraying Llp · Newport, ARN125KTRustair Inc · Anchorage, AKN126AKRohl Shirley J · Anchorage, AKN126MSNance Cattle Co · Birney, MT
Back to AD 80-10-01