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.
N8389LJkg LLC · Murfreesboro, TNN8389MTechnical Education Services Inc T/A · Virginia Beach, VAN8389SGriffith Kevin D · Lakeview, MIN8389TSchupman Joseph M III · Elk, WAN838EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN838HPKeathley Jeremie L · Rolla, MON838KSKansas State University · Salina, KSN838MMZhang Li · Palo Alto, CAN838MPWhitney Stephen · Fort Myers, FLN838PGHinton Michael B · Hesperia, CAN838SPEdb Air Inc · Wilsonville, ORN8390LBliss Marketing Communications Inc · Phoenix, AZN8390THartmann Erich · Puyallup, WAN8390XMoore Laura D · Sacramento, CAN8390ZJp Aero Holdings Inc · Carson City, NVN8391GReynolds Timothy D · Locust Grove, GAN8391JDaily Joshua J · Rochester, WAN8391TRolling Robert A · Oklahoma City, OKN8391XAmerican Aviation Inc · North Wilkesboro, NCN8391ZSkelton Thomas W · Holt, MIN8392BWeber Thomas P · North Bend, WAN8392GSander Clay O · Mutual, OKN8392SCooksey Dustin J · Strasburg, CON8392URegistered aircraftN8393BSingh Gurdev · Cathedral City, CAN8393LJohns Ryan · Sabillasville, MDN8393MPatterson Robert A · Hillsboro, ORN8393SMast Aviation LLC · Roseburg, ORN8393UMadsen Christian A · Hilton Head Island, SCN8393ZDeal Enterprises Inc · Doran, MNN8394QPacific Union College · Angwin, CAN8394TBurke Dennis E · Hermiston, ORN8394XBates Dale R · Cincinnatus, NYN8394ZRegistered aircraftN8395BHughston Chris · Nashville, TNN8395GSmith David B · Indianapolis, INN8395MJuliet Foxtrot Aviation LLC · Camden, SCN8395QN8395q LLC · Ketchum, IDN8395XAccurate Aviation LLC · Spring City, UTN8396GBarnes Greg B · Tunas, MON8396MManley Steven T · Dallas, TXN8396SRegistration Pending · Livingston, MTRegistration pendingN8396XKnierim Erik E · Puyallup, WAN8397BDiaz George D · Tucson, AZN8397JRegistered aircraftN8397QSeattle Seaplanes LLC · Seattle, WAN8397TPennsylvania College Of Technology · Williamsport, PAN8397XGeist Jeffrey A · Avondale, PAN8397ZFlying H LLC · Lake Placid, FLN8398BThal James C · Fredericktown, MO
Back to AD 79-10-14 R1