AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N8139LWashburn Kyle A · Yukon, OKN8139USemanskee Grant W · Snohomish, WAN8139XMerkle Patrick G · Washington, DCN813CAChristiansen Aviation LLC · Wilmington, DEN813CPCivil Air Patrol · Maxwell Afb, ALN813DMAp-1 LLC · Newman Lake, WAN813EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN813GFChristiansen Aviation LLC · Wilmington, DEN813HCGeorgia Forestry Commission · Macon, GAN813HYOcala Aviation Services Inc · Ocala, FLN813JWComanche Air Inc · Tacoma, WAFirst renewal noticeN813KSFargo Jet Center LLC · Fargo, NDN813MDHanks Thomas M · Carlsbad, CAN813PKN813pk LLC · Columbia, MON813SWWolff Scott · Missoula, MTN8140BOlson Larry G · Walnut Creek, CAN8140UAnderson Milton M · Twin Bridges, MTN8140XHubbell Carl · Crowley, TXN8141GBitter Creek Investments LLC · Cascade, IDN8141SRegistration Pending · La Porte, TXRegistration pendingN81424Wbair LLC · Wills Point, TXN8142AKiel Donald G · Whitelaw, WIN8142BJones Ronald E · Cromwell, CTN8142SRebich Jason F · Overton, NVN8142TRodriguez Pablo · Toa Baja, PRN8142UMartin Ralph Edward · Jonesboro, ARN8142VKing Kevin J · Angle Inlet, MNN8142XWhitehead Daniel · New Providence, IAN8142ZHayes Allen D · La Grange, KYN8143ALiimatainen William J · Monroe, WIN8143GRegistration Pending · Sparks, NVRegistration pendingN8143SElite Aeronautics LLC · Carolina, PRN8143TMatheny Larry E · Litchfield, MNN8143UJon Boyd Beard · Houston, TXN8143VCenterline Holdings Inc · Camden, DEN8143ZMoojens LLC · San Carlos, CAN8144BPepper Marcus · San Antonio, TXN8144SRegistered aircraftN8144TShanklin Christopher G · Port Aransas, TXN8144UHansen Kermit E · Ryder, NDN8144VLundahl Frederick B · Langley, WAN8144XBeadles Scott D · Valley Springs, CAN8145AAllen John Jay · Bloomington, ILN8145BRojas Luis Alberto · Riverside, CAN8145SBissat Rishid H · Visalia, CAN8145TLobitz Walter A · Lake Almanor, CAN8145XEast Carolina Aviation LLC · Camden, NCN8146QOak Gulch LLC · Killdeer, NDN8146UBearce Todd A · Phoenix, AZN8146VAnthony Michael L · Sanger, TX
Back to AD 79-10-14 R1