AD 93-16-13
Registered aircraft · 868
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:93-16-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-16-13')
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:93-16-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-16-13') 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.
N9042ZMiller Nanette Renee · Menifee, CAN9043VBulkley James C · Harveys Lake, PAFirst renewal noticeN90448South Taft Liquor Inc · Fort Collins, CON90449Scutt Jared S · Albuquerque, NMN9044ABoyer Donald L · Belen, NMN9044JGarner Kenneth · Decatur, ALN9045PConlin Spencer D · Macomb, ILFirst renewal noticeN9046UJlj Aviation LLC · Little Elm, TXFirst renewal noticeN9047QCowan Melissa G · Nicholasville, KYN90482Avetyan Avetik · Coronado, CAN9049QFisher Loman T III · Waynesville, OHN9049UWilson Harry S · Pagosa Springs, CON904GGH I Flight Inc · Lexington, KYN9051SCooper Lewayne F · Staples, MNN9051YGneiting Scott J · St George, UTN90523Duncan Brian J · Spring, TXN9052NAamodt'S Hot Air Balloon Rides Inc · Stillwater, MNN9053GSpais David P · Willingboro, NJN9054VHandcrafted Furniture Balloon Rides LLC · Lake Tomahawk, WIN90550Boyer Donald L · Belen, NMN90556Krause Shawn L · Zachary, LAN90568Griswold Scott R · Selkirk, NYN9056GAuer Joshua J · Fallbrook, CAN9056ZSpencer Jennifer A · Mccordsville, INN9058YFleur De Tucson Balloon Tours LLC · Red Rock, AZN90593Harden Jesse R · Colorado Springs, CON9060YSpacious Skies Lc · Cedar City, UTN90622Eichhorn David J · Corrales, NMN90632Stevenson Frank W · Frankfort, KYN9064HBalloon Quest Inc · Fenton, MIN9064MAdams Tyler J · Kennewick, WAN9065DWeaver Christopher A · Huntsville, ALN9066DShane Micheal P · North Ogden, UTN9066NTscc Services LLC · Frisco, TXN90677Hallesy Micheal K · Epping, NDN9067RYohn Richard K · Reedsville, PAN9069SBost Randall D · Arkadelphia, ARN90701Balcom Lina V · Milton, VTN9070QEichhorn David J · Corrales, NMN90712Jones Robert Joel · Seale, ALN9071FHall Robert B · Germantown, TNN9072PKeown Owen B · Malibu, CAN9074YDakota Sunrise Balloon LLC · Horace, NDN90762Weiner Kenneth H · Jamestown, RIN9077GNj Tech Medics LLC · Neshanic Station, NJN90787Lesmeister Michael A · Rochester, MNN90792Churchman Mark A · Lebanon, TNN9082FWind Dancer Promotions Inc · Canton, MSN9083CRidge Hoppin' LLC · Richmond, VTN90843Rally Aviation LLC · Saint Louis, MO
Back to AD 93-16-13