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.
N6358FHarrison Zuzana · Albuquerque, NMN6358SStancil Joseph E Jr · Eagle River, AKN63595Beard Bruce H · Pocatello, IDN63596Parke Helen M · Kent, WAN63598Hollrah Richard E · Enid, OKN63599Burkel Robert G · Hemet, CAN6359ASutton Aircraft Salvage LLC · Palmer, AKN6359BRoss Stout Architect Inc · Indian Wells, CAN6359DFlying Vikings Inc · Hayward, CAN6359KMaierhoffer Henry F DBA · Sylvania, GAN635BASvetfur Aviation LLC · Camden, SCN635BKGuilford County · Greensboro, NCN635CGLongstreth James E · Powhatan, VAN635CPCivil Air Patrol · Maxwell Afb, ALN635CRChristiansen Aviation LLC · Wilmington, DEN635CSTextron Aviation Inc · Wichita, KSN635MSpl Invest LLC · Chandler, AZN635NDEveryday Airman LLC · Seattle, WAN635SPAtp Aircraft 2 LLC · Wilmington, DEN63605Lowcountry Aviation Company Brokerage LLC · Walterboro, SCN63608Klug Brian V · Speonk, NYN63609Filtenborg Daniel · Shelbyville, MIN6360AClaiborne Howard · Cottonwood, CAN63610Frantz Paul · Palmyra, PAN63612St Charles Flying Service Inc · Portage Des Sioux, MON63617Johnston Daniel · Virginia Beach, VAN63619Beard Jeffrey L · New Oxford, PAN6361FTramper Air LLC · Rockford, MIN6361GHalley Dan R · Avery, TXN6361SSchade Scott · Green Valley, AZN63620Florida Airplane Recovery LLC · Tallahassee, FLN63621Macgregor Sinclair · Oroville, CAN63626Nelson Matthew J · Frewsburg, NYN63628Black Hills Airplanes LLC · Rapid City, SDN6362AMillican Clifford A · Burleson, TXN6362BSimplot Don J · Boise, IDFirst renewal noticeN6362EYoungblood Harley O III · Vancouver, WAN6362FCabral Nicholas · Oldsmar, FLN6362SMott Charles A Jr · Chesapeake, VAN63632Prestige Air Charter Inc · Sandston, VAN63637Oclair Justin B · New Canada, MEN63638Skywagon LLC · Wilmington, DEN6363AWong Adrian Trustee · San Francisco, CAN6363EHanson Douglas L · Montpelier, VTN6363GGillis Timothy L · Kenai, AKN6363KKnoblock Stephen A · Acworth, GAN6363SSnell Matthew L · Ackerly, TXN63641Cole Warren G · Watkinsville, GAN63645Greene Roswell J · Punta Gorda, FLN63646Reed Phillip · Lanesboro, MN
Back to AD 79-10-14 R1