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.
N7142SGarcia Michael A · Albuquerque, NMN7144COliver James B · Canandaigua, NYN7144ESchmitz Jon F · Albuquerque, NMN71459Hanson Gregory K · De Witt, IAN7145FTroxclair Edward M · Rio Rancho, NMN7146CLesmeister Michael A · Rochester, MNN7146JBarrick April R · Bosque Farms, NMN7146VLamm Emerson A · Lakewood, CON7148BSchreiber James E · Longwood, FLN7148GDakota Balloons LLC · Hot Springs, SDN71493Lesmeister Michael A · Rochester, MNN7150USimonye Curtis F DBA · Fishers, INN71520Caton Thomas J · Byrnes Mill, MON7152ZClark Joseph L · Ravenna, OHN7153XKrieg Fred W · Independence, ORN7155JMarketing Services Inc Of Pueblo · Colorado Springs, CON7155ZDe Koevend Enterprises Inc · Fort Garland, CON7156HPerkins Michael D · Las Vegas, NVN71579Weiscopf Charles W · Roseville, CAN7158TBrown Charles S Jr · Mount Washington, KYN7158ZLighter Than Air America · Boise, IDN71604Carreathers Lonnie D · Corrales, NMN71606Balloonatics And Aeronuts LLC · Belvidere, NJN7160BTagtow Amanda · Colorado Springs, CON7161MWiser David B · Bixby, OKN7161NCarreathers Lonnie · Rio Rancho, NMN7161YGingerich Joseph L · Plain City, OHN7162LAnderson Abruzzo Intl Balloon Museum Foundation · Albuquerque, NMN71630Smith Bergen D · Reno, NVN71631Aamodts Hot Air Balloon Rides Inc · Stillwater, MNN7163ALiberty Balloon Holdings LLC · Groveland, NYN7163SBookman Benjamin I · Colorado Springs, CON7164PDay Don · Cheyenne, WYN7164XBlack Steven E · Galva, KSN71663Turoff Peter J · Lagrangeville, NYN71674Thrond Gerald A · Santa Ana, CAN71679Sun Flyer Balloon LLC · Albuquerque, NMN7168CRally Aviation LLC · Saint Louis, MON71695Rieger Virginia J · Sheridan, WYN71696Richardson Molly · Brandon, SDN7169CSlagle Poteet Mary Ann · Wolfforth, TXN7169SAir Hound Adventures LLC · Davenport, FLN71709Ozarks Balloon Adventures LLC · Ozark, MON7170CBalloon Talk LLC · Bloomfield, NJN7170JWeiss William B · Rochester, MNN7170MBrown Charles S Jr · Mount Washington, KYN7170TReeves Keith F · Albuquerque, NMN7171BSale Reported · Centralia, ILSale reportedN7171HAir America Promotions Inc · Deltona, FLN71729Personal Investment And Managed Properties LLC · Catawissa, MO
Back to AD 93-16-13