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.
N925YZFranchetti Kevin · Manchester, MEN92600Windh Steven R · Reedley, CAN9260CWilson Benjamin W · Carrollton, TXN9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeN9260UFlying L Aircraft Inc · Fort Denaud, FLN9260XColvin Buster · Big Cabin, OKN92616Holby W Barrett Jr · Warren, RIN92617Stahl Raifen · Anchorage, AKN9261ACallahan Glenn P · Deridder, LAN9261GAllred Bobby A · Centre, ALN9261HSchrom Frederick A · Carlisle, PAN9261UOconnor Sean P · Pompano Beach, FLN9262HAero Maintenance Inc · Vancouver, WAN9262UNichols Curtis E · Gloucester, VAN92638Van Raden Chris · Portland, ORN92639Pryor Aviation LLC · Hutchinson, KSN9263GN9263g LLC · Marshall, MON9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNN9263XMieloszyk Nicholas A · Elko, NVN92644Atkins Doug · Murfreesboro, TNN92648Bender Phillip H · Bloomingdale, OHN9264RAir Dakota Flite Inc · Hettinger, NDN9265CComerford John W · Pagosa Springs, CON9265HCleveland Douglas P · Live Oak, FLN9265TFpg Agri Services LLC · Frost, TXN9265UEtchell Bruce R · Healdsburg, CAN9265XWestern Pilot Service Inc · Phoenix, AZN92665Rupke Curtis · Washington, NCN9266ADyrstad Mary S · Hampshire, ILN9266GCole Mark A · Forest City, NCN9266UEgge Danny C · Pelican Rapids, MNN9266XWeichert Robert S · Parker, CON9266ZR M B G Inc · Winnsboro, LAN92675Miller Saima A · Kodiak, AKN92677Burriss James E · Piedmont, SCN9267ABrown Craig A · Airway Heights, WAN9267GWaypoint Financial Services LLC · Raiford, FLN9267TDeeds Andy · Larkspur, COFirst renewal noticeN9267UDavis Andrew P · Leominster, MAN92680E & T Research And Development LLC · Sanford, NCN9268UIbrahim Motaz · Goodyear, AZN92690Nelson Richard B · San Mateo, FLN92691Registration Pending · Lebanon, TNRegistration pendingN9269ABriggs Aviation LLC · Virginia Beach, VAN9269BHaataja Charles M · Two Rivers, WIN9269HLargen Gregory K · Benton, KSN9269TAlsworth Leon R · Port Alsworth, AKN9269UDennis Matthew C · Transylvania, LAN926CPCivil Air Patrol · Maxwell Afb, ALN926CRAero Tech Services Inc · Lititz, PA
Back to AD 79-10-14 R1