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.
N5003KJohnson Neil C · Albuquerque, NMN5004SJohnson Michael R · Mitchell, NEN5004TDavison Associates Inc · Phoenix, AZN5004ZRegistration Pending · Yale, SDRegistration pendingN5006QZion Balloons Utah LLC · St George, UTN50125Gatfield Kelly E · Douglassville, PAN5012UFleury Michael A · Red Rock, AZN5013DPerfect Flight LLC · Albuquerque, NMN5013JSproul Keith · North Brunswick, NJN5013LLattin Thomas K · Garner, NCN5013NAeronautical Adventures Inc · Eagle, IDN5015BLong Edgar E · Lake Alfred, FLN5019CKlitz Thomas J · Payson, ILN5019VSky Sail Balloons Inc · Ashville, NYN5021LDavenport Richard B · Ormond Beach, FLN5023DDeisignore Michael A · Glens Falls, NYN5023USky Times LLC · Fayetteville, ARN5024UTimblin Joel R · Boyceville, WIN5025KAbove The Clouds Inc · Middletown, NYN5025LDigiovanni Ronald T · Milford, NJN5025XO Brien James A · Orange, CTN5028JSale Reported · Albuquerque, NMSale reported, pending cancellationN5030JSimburger Larry · Enumclaw, WAN5030YMay Rodney A · Albuquerque, NMN5031DCavin John · Indialantic, FLN50416Post Balloon Club Inc · Battle Creek, MIN5043URushkarski Dawne Renae · Monroe, WAN50440Businessgoals LLC · Murray, UTN50461Alexandria Balloon Flights · Milford, NJN50466Shane Michael · North Ogden, UTN5055FLittle Kaitlin R · Stillwater, OKN5076BOliviann Balloons LLC · Hodgenville, KYN5085GNelson Tim · Rancho Murieta, CAN5089BSkycab Balloon Promotions Inc · Louisville, KYN50965Rally Aviation LLC · Saint Louis, MON5109NByberg Bruce E · Whitehouse Station, NJN5111CYoung Carl E · De Witt, IAN5112BRitland Christopher M · Quechee, VTN51164Daoust Darrek · Quechee, VTN5124QJohnson Andrew J · Enumclaw, WAN51267Stockley Don · Murray, UTN51371Balloonacy LLC · Fayetteville, GAN51417Green Kevin M · Gilmer, TXN51476Wheeler James H · Bryan, OHN51489Brielmann Kevin C · Cromwell, CTN5148CRegistration Pending · Winneconne, WIRegistration pendingN51548Air Albert Lea · Albert Lea, MNN5156TPure Magic Balloon Team LLC · Bristol, WIN5161YFavero Marcus F · Smithfield, VAN51762Bb Aero Works Ltd · Whitehouse, OH
Back to AD 93-16-13