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.
N642ABauer Thomas M · Elizabethtown, KYN642AWHobart Aviation Inc · Akron, OHN642KMNick Heir LLC · Lexington, KYFirst renewal noticeN642MALittle Bird 150 LLC · Parsons, TNN642NDPelican Flight Training LLC · San Carlos, CAN642RSRomeo Sierra Aviation LLC · Sparks, NVN642SPBlue Sky Aviation Association Inc · Readington, NJN642THFairmont State University · Fairmont, WVN642WRN642wr LLC · Henderson, NVN64301B&R Aircraft LLC · Wadsworth, OHN64302Lanehart Zachary · Keo, ARN64303Acey Services LLC · Cumming, GAN64305Skyhaven Flying Club Inc · Dover, NHN64307Flywyo LLC · Kalispell, MTN64308Rein Robert G · Seattle, WAN64309Sveta Kadirova · Louisville, KYFirst renewal noticeN6430ATulsa Technology Center School District No 18 · Tulsa, OKN6430XLegner Leasing LLC · Las Vegas, NVN64313Aerial Scouting Solutions LLC · Sioux Center, IAN64314Registration Pending · New Bern, NCRegistration pendingN64317Spernak Airways Inc · Anchorage, AKFirst renewal noticeN6431BStecconi Ferraro Denise M · Seattle, WAN6431EGroup 172 LLC · Tucson, AZN6431GSoule Clauson D · Cooperstown, NYN6431NMorton Craig Allister · Toluca Lake, CAN6431THarrigan Bernard J · Fontana, WIN64325Varney Aviation LLC · Bangor, MEN64328Compass Aviation Inc · Shelby, NCN64329Bvs Aviation LLC · Burns, ORN6432BSmith Robert E Jr · Shell Knob, MON6432VShortridge Randall R · Mesa, AZN64330Cornelius Beverly B · Merrill, WIN6433232 Leasing LLC · Englewood, CON64333Sawtooth Aviation LLC · Hovland, MNN64334Vrionides Polis G · Collinsville, CTN64335Cox Dennis J · Beach City, TXN64336Moore Joseph C · Farmers Branch, TXN64337Clearwater Airco LLC · Anchorage, AKN6433AWagar Dennis Murphy · Marion, MTN6433EMorgan Peter F · Parma, IDN6433SDandrea Robert · Portage, PAN6433XRand Carl · Durango, CON64340Spartan Aviation Services LLC · Parkland, FLN64344Pensacola Navy Flying Club Inc · Pensacola, FLN64345Sundstrom Jeffery V · Fresno, CAN6434NDecker Rufus G III · Arlington, VAN6434RCutlass Aviation LLC · Auburn, ALN6434THoran Jack F · De Berry, TXN64350Byrne David D · Essex Fells, NJN64355N64355 LLC · Boulder, CO
Back to AD 79-10-14 R1