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.
N7172HDrummond Julian N M · Monument, CON7172YGwin Corey J · Hot Springs, SDN71747Johnson Elizabeth C · Mitchell, NEN7174RWicked Balloons Inc · Worcester, MAN71756Richardson Shane R · Albuquerque, NMN7176KWash Luke W · Ashland, OHN7177ZBreeden Timothy M · Spanaway, WAN7180KForrest Services LLC · Dayton, NVN7180TAdler David Mathew · Yuma, AZN721USMiller Howard G Jr · Atmore, ALN7331MSomething Kinda Special LLC · Colorado Springs, CON74RSKuehlmuss Michael · Whately, MAN74TNGallegos Frank L · Los Lunas, NMN77820Arkwell Kathy A · Peoria, ILN783TPNilz R Patrick · Tucson, AZN79FATiffin Aire Inc · Tiffin, OHN79UWBrittingham Carl H · Rochester, MIN824XGHewitt Ronnie E · Villa Rica, GAN87RAJones Cameron D · Statesboro, GAN88DCBorts Wyman L Jr · Des Moines, IAN89TLDream Chasers Balloon Team LLC · Palm City, FLN90002Fantasy Balloon Flights Inc · Port Jervis, NYN90006American Balloon Rides LLC · Land O Lakes, FLN9000CWilliams David M · Westtown, NYN9005WSanderson Alan R · Albany, ORN9005YHuesers Patrick S · Saint Joseph, MNN9006DCopper Star Balloons LLC · Phoenix, AZN9006XGordon Mary E · East Canton, OHN90073Acuff Laurie · Manito, ILN90096Schindele Michael D · Tolna, NDFirst renewal noticeN9009PFreedom Flight Inc · Saint Cloud, MNN90218Geib Jessica N · Seattle, WAN9021JSorenson Katherine L · Murray, UTN9021TOliviann Balloons LLC · Hodgenville, KYN90234Post Employees Balloon Club · Battle Creek, MIN9024QBims Balloon Bonanza LLC · Neshanic Station, NJN90266Gould Diana M · Shelburne, VTN9028NCole Timothy S · Greeley, CON9029ZMonahan Todd J · Queensbury, NYN90300Casaus Shelby L · Gardnerville, NVN9031RRandolf Ronald D · Corpus Christi, TXN9032JH I Flight Inc · Lexington, KYN9037GKetchner Vickie N · Wellsville, NYN9038ZPersonal Investment And Managed Properties LLC · Catawissa, MON90399Kokopelli Aviation LLC · Tucson, AZN9039JBracht David R · Somerset, WIN9040MMiller Greg S · Prineville, ORN9041BKiehle Erik A · Meridian, MSN9041LGrant Daniel R · Pawtucket, RIN90427Kemp John D · Las Cruces, NM
Back to AD 93-16-13