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.
N6320GBurks Michael S · Shoshone, IDN6320HWaypoint Corp · Clearwater, FLN6320RGehr Garner J · Eustis, FLN63210Johnson Mark L · Bend, ORN63211Prestige Worldwide Charters LLC · Edgartown, MAN63214Brady William Berte · Venice, FLN63219Cresap Dale A · Idaho Falls, IDN6321FSolar Repair Center Inc · Beaumont, CAN6321GFurlong Kelly · Athens, ALN6321HBluebird Inn Inc · Fish Haven, IDN6321KBrookby John M · Grand Prairie, TXN6321SStoker Dana R Trustee · Tucson, AZN63220Ronchini Denis · Haverhill, MAN63221Ruebush Joshua K · Eaton, OHN6322FKamp LLC · Kalispell, MTN63231Stafford Anthony T · Collierville, TNN63233Gill Charles D · Baton Rouge, LAN63234Guerrero Erwin F · South Bend, INN63237Biemer Alexander · Spring Branch, TXN6323AGlick Brady M · Colorado Springs, CON6323BJennett Cheryl K · Phoenix, AZN6323ESwedish Flying Couching LLC · Franklin, WIN63242Douglas Dustin D · Tea, SDN63244Bacus Brent · Indianapolis, INN63246Musser John R · Freeport, ILN63248Lewis Luther Daniel · New Bern, NCN6324ADiaz Anthony V · Salinas, CAN6324GArmstrong Paul · San Francisco, CAN6324KRegistration Pending · Princeton, NJRegistration pendingN6324SKleis Richard L · Zwingle, IAN63251Christiansen Aviation LLC · Wilmington, DEN63252Bork Michael F · Kalamazoo, MIN63256Bridge To Freedom Investments LLC · Atlanta, GAN63258Cleven Randall L · Moncure, NCN63259Lloyd Kevin S · Tacoma, WAN6325APrestegard Michael L · Delta Junction, AKN6325DCox Ronnie L · Whitesburg, GAN6325EHaider Ronald J · Southlake, TXN6325SConfer Mark A · Fort Wayne, INN63260Van Hise Austin S · Fort Denaud, FLN63263Debonair Solutions LLC · Leesville, LAN63265Cessna Flyers LLC · Zephyrhills, FLN63267W A Redgate · Crescent Valley, NVN6326ANipper Melanie T · Defuniak Springs, FLN6326EKevin Formica Inc · Boca Raton, FLN6326FAirtime Holdings LLC · Charleston, SCN6326GStephani Timothy M · White Lake, WIN63270Louise Flyers LLC · Cheyenne, WYN63272Glantz Charles P · Albuquerque, NMN63273Hlavinka Terrance J · East Bernard, TX
Back to AD 79-10-14 R1