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.
N738SRRise Aviation LLC · Auburn, ALN738SSFalcon Aire LLC · Mequon, WIN738STBergstrom Aircraft Inc · Pasco, WAN738SUNab Aviation Holdings LLC · Cocoa Beach, FLN738SYVan Anda Aviation LLC · Apopka, FLN738TBSorbi Aviation Inc · El Cajon, CAN738TGWings Aero LLC · Zeeland, MIN738TJGlendale Community College · Glendale, CAN738TMBrown Clifford · League City, TXN738TNBarnett Mary C · Upland, CAN738TPLacey Christopher · Cape Coral, FLN738TQLake Travis Flyers LLC · Granite Shoals, TXN738TTRfc Inc · Hiawatha, IAN738TVGordon Benny B · Columbia City, INFirst renewal noticeN738TXLavalley Asset Management Inc · Potsdam, NYN738TZRegistration Pending · Fort Worth, TXRegistration pendingN738UDAffection Above Aviation Inc · Yukon, OKN738UESteinkamp Loren L · Fairmont, MNN738UHSale Reported · Calabasas, CASale reportedN738URCooper William J Jr · Littleton, NCN738UTWright Flyer LLC · Palm Coast, FLN738UWAircraft Management Services Inc · Milton, FLN738UYOptima Aviation LLC DBA · Lewisville, TXN738VAFive Rivers Flight Training LLC · Livermore, CAN738VBBrafa Frank T · Leesville, LAN738VCMarlin Walter E II · Locust Grove, GAN738VJCommand-Aire LLC · Seattle, WAN738VLBasler Leon E · Sainte Genevieve, MON738VRWoodward Tyler James · Norman, OKN738VUFive Rivers Flight Training LLC · Livermore, CAN738VVPureflight Aviation Training LLC · Newberg, ORN738VYRpm Aero LLC · Lincolnwood, ILN738WCBrb Grand-Air LLC · Indiantown, FLN738WEBray Aviation LLC · Calera, OKN738WGZlock David · Lakeville, MNN738WJSpann Leonard D · Little Rock, ARN738WLBrenair Inc · Mcalester, OKN738WMMayers Trevor D · Miami, FLN738WNSkywarrior Flight Training LLC · Pensacola, FLN738WRRoberts Dwight C · Seminole, OKN738WYIsland Aircraft LLC · Anchorage, AKFirst renewal noticeN738WZPitman Steven M · Lyman, SCN738XAHyldburg Aviation · Plymouth, MAN738XDMls Aviation LLC · Yorba Linda, CAN738XFTynan Flyers LLC · Tynan, TXN738XGWest Central Georgia Flying Club · Thomaston, GAN738XKBailey James D Trustee · Marana, AZN738XLM&A Aviation LLC · Vine Grove, KYN738YBMark Stoughton · Salley, SCN738YCN738yc LLC · Fresno, CA
Back to AD 79-10-14 R1