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.
N7RABeck James E · Palacios, TXN7RDSchipper Properties Inc · San Jose, CAN7REMid Tex Controls Inc · Krum, TXN7RRTavan Richard M · Saratoga, CAN7RVHartzell Joseph J · GrandvauxN7RWNelson Jeffrey S · Darby, MTN7SQTangassi Sergio · Gilbert, AZN7STFairley Dustin L · Fairbury, NEN7TTWright Gregory B DBA · Amarillo, TXN7UBWhite James V · Prescott, AZN7UTVolunteer Aviation Foundation Inc · Tullahoma, TNN7VJM E L LLC · Wilmington, DEN7XYHewett Nancy A · Tacoma, WAN7YXOc Aviators LLC · Troy, TNN7YZAeronautical Enterprises LLC · Woodinville, WAN7ZXRobinson Leslie C · Colorado Springs, CON8000ABonnette William A · Gill, MAN8000BRoberts David C · Sidney, IAN8000TBas Part Sales LLC · Greeley, CON8000VCga Holdings LLC · Kalispell, MTN8000XRush Adelaide K · Anchorage, AKN8000YConklin Matthew J · Boise, IDN8001BRobinson Stephen A · London, KYN8001FJohnston Joshua T · Aurora, MON8001GWilliams Matthew L · Longview, TXN8001LHoupt David · Clinton, OHN8001ZGfi Investments LLC · Gillette, WYN8002KTrepanier Dennis A · Santa Fe Springs, CAN8002TBierer David E · Victor, MTN8002ZNash Richard · Missoula, MTN8003BLeopardi David E · Salt Lake City, UTN8003FNovember Fox LLC · Quilcene, WAN8003LCrump Shawn C · Gonzales, LAN8003TAcker Brandon D · Portland, ORN8003XSwenson Donald C · Stanchfield, MNN8004ABernhardt Michael J · North Branch, MNN8004SRege Bill · Cloverdale, CAN8004XSchriever Rebecca M · Lees Summit, MON8005AWalker Aviation LLC · Big Timber, MTN8005GBertolino Vincent · Canton, CTN8005JWelch Louis · Granbury, TXN8005QMaslen Holbrook · Reno, NVN8005SFletcher Michael A · Vancouver, WAN80066Boring Troy K · Belleville, PAN80069Easley Kevin M · Anchorage, AKN8006GGecin Taner · Wallingford, CTN8006LGmdg LLC · Shreveport, LAN8006SBering Capital LLC · Anchorage, AKN8006ZMathews Vincent W · Bryan, TXN80070Neb City Building Inc · Anchorage, AK
Back to AD 79-10-14 R1