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.
N5185PBlackburn Jonathan C · Cottonwood Heights, UTN51985Hooper Roger · Hutchinson Island, FLN5198AAshton Randy D · Boise, IDN52078Kus Kenneth · Chagrin Falls, OHN52098Fournier Douglas J J · Abilene, TXN5209KBowie Manning · Trenton, SCN52249Balloon Quest Inc · Fenton, MIN5228WH I Flight Inc · Ripley, TNN5230RDavenport Richard · Ormond Beach, FLN52319Cretu Monica · Redmond, WAN5231JLoesser Kenneth A · Annandale, NJN5231YBeebe Kenneth J · Rio Rancho, NMN52323Catskill Mountain Balloon · Oneonta, NYN5232SMroz Stephen · O Fallon, MON5236EMiller Michael J · Grafton, OHN5237SBeebe Kenneth J · Rio Rancho, NMN5241BNichols Mark A · Ridgefield, WAN5242MMroz Steve · St Paul, MON52435Tf Hampton Ventures Inc · Columbus, OHN5243BMarkus Gregory A · Centralia, ILN5243JUtah Outventures LLC · South Salt Lake, UTN52455Bullock John W · Wausau, WIN52461Back Country Ballooning LLC · Tres Piedras, NMN5246NAnthony Johnny R · Sandia Park, NMN5246RLattin Thomas K · Garner, NCN5247PDavison Associates Inc · Phoenix, AZN5251QStroup Karen · Wooster, OHN52541Young Carl E · De Witt, IAN5254MFlying Circus Inc · Custer, SDN5258DFerrall Richard D · Lawrenceville, GAN5258MLutkus Janet · Medina, OHN5268ZYoung Carl E · De Witt, IAN5271ECamelot Balloons · Basalt, CON5272YShrum Michael L · Box Elder, SDN5274TNoel Benjie B · West Monroe, LAN5276RSproul Keith A · North Brunswick, NJN5276TWadsworth William · Albuquerque, NMN5277APhelan Jim E · Lincoln, ILN5277ZLattin Thomas K · Garner, NCN5278AJones Robert J · Seale, ALN5279EMaxwell-Griego Zackery W · Albuquerque, NMN5279RChico Timothy G · Vista, CAN527RRHamrick Jason N · Billings, MTN52801Backes Daniel A · Florence, AZN52804Miller Nanette R · Menifee, CAN5280LNewkirk Rodney A · Rochester, MNN5281KSkyline Hot Air Balloons LLC · Fishers, INN52826Johnson Amanda L · Prosser, WAN52827Skylands Ballooning LLC · Blairstown, NJN5282QAerostat Adventures LLC · Ormond Beach, FL
Back to AD 93-16-13