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.
N9119NForden Noah · Saunderstown, RIN91201Lambert Steve · Daytona Beach, FLFirst renewal noticeN9121KJohnson Robb C · Council Bluffs, IAN9122BBowling David C · Colorado Springs, CON9123SCaswell Richard E · Eighty Four, PAN9123UWind Dancer Promotions Inc · Canton, MSN9124GHoyle Kenneth B · Raleigh, NCN9124JDrennan Benjamin B · Cordele, GAN91253Bb Aero Works Ltd · Whitehouse, OHN9125QKuller Timothy D Trustee · Mesa, AZN91265Cole Joseph W · Town Creek, ALN9126BDcg & Associates Inc · Rio Rancho, NMN9126KSee Glenn M · Albuquerque, NMN9128CRegistered aircraftN9130FAkins Rocky D · Cedar Hill, MON9130QCuadrado R · Miami, FLN9132ZMcvay Gilbert L · Trenton, MON91339Forrest Services LLC · Dayton, NVN9133NBost Randall D · Arkadelphia, ARN91355Camelot Balloons Inc · Basalt, CON91362Zing Aerosports LLC · Peoria, AZN9136JFogle Timothy Jay · Elko, NVN9139ECato Amie D · Commerce, TXN9139VPrairie Sky Inc · Custer, SDN9141HOdom Gary Eure · Valparaiso, FLN9142NJones Janell · Grass Valley, CAN91443Aero Force Balloons LLC · Simpsonville, KYN9146CBallooning Society Of Pikes Peak · Colorado Springs, CON9146SNusz Hannah · Durango, CON9146TNajewski Edwin R · Tinley Park, ILN9147JHampton Regina · Albuquerque, NMN9150QEstoup Matthew W · Walla Walla, WAN9153DMississippi River Balloon Transit Co Inc · Saint Louis, MON9155SSproul Keith A · North Brunswick, NJN91575Olin Michael A · Warner, NHN9158ZWilson Petra · Hot Springs, SDN91739Pata John · Rio Rancho, NMN9174FBusinessgoals LLC · Salt Lake City, UTN9174XVertrees Joe H · Brea, CAN9175FMichigan Balloon Adventures · Mason, MIN9175TStepanek Edward Britan · Cleveland, NCN9175UBalloonacy LLC · Fayetteville, GAN91764Christianson Brian P · Glenburn, NDN9176BMontgomery Daniel C · West Jordan, UTN9176QCox Jordan R · Carmel, INN9177NDumke Ralph D Jr · Florence, WIN9178NMccoy Gayle D · Spring Creek, NVN9178RWakker William A · Valleyford, WAN9178ZTewksbury Balloon Adventures LLC · Whitehouse Station, NJN9179GMiller Morgan Tyler · Riverton, WY
Back to AD 93-16-13