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.
N58469Caj Holdings LLC · College Station, TXN5846AHalford Richard W · Eagle River, AKN5846ESale Reported · Ohatchee, ALSale reported, pending cancellationN58470Kraiger Rockne C Trustee · Galesburg, MIN58472West Central Construction LLC · Indian Valley, IDN5847ACochran Josh · New Orleans, LAN5847BHart Johndale · Pagosa Springs, CON58483Thaxton James T · Mcminnville, TNN58484Centurion Enterprises Inc · Lake Elmo, MNN58488Gillies Ken G · Stockton, CAN5848BOdenbrett Jeffrey E · Brighton, CON5848GDerby City Aviation LLC · Vero Beach, FLN58496Gubran Robert S · Monterey Park, CAN58498Wooding William W · Anacortes, WAN5849AAllison Michael L · Lubbock, TXN5849JFowler Jon E · Hallock, MNN584AFAda Forestry Division · Malvern, ARN584LQAir Shares LLC · Casper, WYN584SFDsr Cherokee 180 LLC · Dallas, TXN584SPTexas State Technical College At Waco · Waco, TXN58502H E Fly Float LLC · Virginia Beach, VAN58504P S C Flyers · Cardiff By The Sea, CAN58505Pike Medical Inc · Chillicothe, OHN58506Krume Eric R · Castle Rock, WAN5850F5850f LLC · Monroe Township, NJN58515Cowan Michael A · Buckeye, AZN58517Walthers Michael L · Portland, ORN58518N58518 Flying Club LLC · Vancouver, WAN5851RSmoky Bear Air LLC · Rockwood, TNN58522Ryan Donald E · Fort Payne, ALN5852BShaw David V · Colville, WAN5852FAlvidrez Investments Group Inc · Lakewood, CAN5852GSwigart Davis Holdings Inc · Upland, CAN5852RBenien Dennis A · Napoleon, OHN5853ADanz Frederick C · Mattawa, WAN5853GJohnson Robert K · Monte Rio, CAN5853RHall Gary M · Muncie, INN58546Satara Inc · Frisco, TXN58548Khbp LLC · Donnelly, IDN58549Sale Reported · Rio Rico, AZSale reported, canceledN5854BCruson James W · Spring Creek, NVN58554Mocking Bird Aviation LLC · Hanover, PAN58558Long William E · Old Town, FLN5855BCudahy J Patrick · Bayside, CAN5855FOrmiston Air LLC · Kismet, KSN5855RDonelan Matt B · Springfield, ILN58560N58560 LLC · Zionsville, INN5856EBudde Bobby Jr · San Jose, CAN5857ABrandt Jeff D · Ankeny, IAN5857BObrien Terence · Bonney Lake, WA
Back to AD 79-10-14 R1