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.
N86220Gardner Daniel J · Alvord, TXN86227Kantorowicz Tammy · Great Falls, MTN8622TBothell Eric L · Center, CON8623SBucks Flight Academy LLC · Cashion, OKN8623UBarry Gehret · Sonoma, CAN8623ZHauze John W · San Antonio, TXN8624SToth Frank L · Schenevus, NYN8624USikora Randall P · Boca Raton, FLN86255Handley Air Corporation · Boulder, CON86256Steven M Gilreath · Anderson, SCN8625GDelong Erika Dee · Forest Lake, MNN8625SMendoza Erik · Pleasanton, TXN8625TChisum Lance A · Boise, IDN8625URubison John R · Shelbina, MON86261Odle Scott Thomas · Redmond, WAN8626GMcflight Aviation LLC · Highland, UTN8626JSeitz David J · Mauston, WIN8626THibbert Walter W · Otto, WYN8626UFriedman Arthur M · Santa Paula, CAN8627GMahaini Saad · Lucas, TXN8627TRegistered aircraftN86285Caradine Jimmie P · Commerce, TXN86289Hudec John S · Crown Point, INN8628BScarcella Joseph A · Redlands, CAN8628GLongmuir Charles H · Newport, MEN8628JJacobi Joseph · Mexico, MON8628SDiaz George D · Tucson, AZN8628TR&D Aviation Holdings LLC · Bellville, TXN8628UTownsend Slade · Fredonia, TXN8628ZSaddler Susan J · Dayton, OHN8629TWoodworth Mark P · Golden, CON8629UHedberg Paul D · Atwater, MNN862AUAuburn University · Auburn Univerity, ALN862CBFolk Tom M · Puyallup, WAN862CPN862cp LLC · Stuart, FLN862PZBuntzman Gabriel F · Bowling Green, KYN862TWTailwinds LLC · Ewing, NJN862WBWings Of Blessing · Ft Worth, TXN86303Van Dootingh Jeffrey A · Middle Bass, OHN863062fly-Safety LLC Trustee · Azle, TXN8630GGoehring Melissa S · Grand Rapids, MIN8630JDean M O · Corpus Christi, TXN8630THensley Steven Lee Jr Trustee · Scappoose, ORN8630UOcala Aviation Services Inc · Ocala, FLN8630ZAlaska Village Missions · Homer, AKN8631JKing Boyd F · Okmulgee, OKN8631SSteiger Marley C · Glenham, SDN8632GChappell Stephen · Wilmington, NCN8632TLucky Resin Works LLC · Bend, ORN8632ZTate Roger · Redlands, CA
Back to AD 79-10-14 R1