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.
N6519QFox Thomas B · Steamboat Springs, CON6526RKugler Donald W Jr DBA · Baptistown, NJN6526SDavis John C IV · Evergreen, CON65308Young Derald E · Dixfield, MEN6532BCreative Concepts Advertising Inc · Aurora, ORN6541XWais Richard J · Oak Harbor, WAN65540Digiovanni Ronald T · Milford, NJN6563QLake Geneva Balloon Co LLC · Lake Geneva, WIN65652Drennan Benjamin B · Cordele, GAN6569XSproul Keith A · North Brunswick, NJN65705Wrigglesworth Mark N · East Amherst, NYN65778Gallagher Eric J · Downingtown, PAN65793Lattin Thomas K · Garner, NCN6580BDuft Jeff M · Eagle River, AKN6584CBelk William E · Labelle, FLN65850Gerred Michael S · Bel Air, MDN65ABGallant Michael T · Columbus, INN690AMHrechniw Taras K · Ellenville, NYN69MCSproul Keith A · North Brunswick, NJN69SPHandcraft Furniture Balloon Rides LLC · Lake Tomahawk, WIN70016Albert Daniel L · New Athens, ILN70120Magniflight LLC · Arlington, TXN70147Transworld Balloon Management Inc · Deptford, NJN7019GSmith Robert · Pittsburg, KSN70240Klein Raymond O · Scottsdale, AZN7024MCox Jordan R · Indianapolis, INN7024RRaveair LLC · Bountiful, UTN70289Fernandes Alta M · Turlock, CAN7029CHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTN7029QPratt Thomas V · Rancho Cucamonga, CAN7036HTollefson Tom G · Detroit Lakes, MNN7036YHicks Jason F · Denver, CON7037NBennett Jeff A · Tulsa, OKN7040ZWind Dancer Promotions Inc · Canton, MSN70451Bradley David · Indianapolis, INN70467Balloon Talk LLC · Bloomfield, NJN7046JRegistered aircraftN-number assigned, not yet registeredN7055BLutz Julius K · Saint Charles, MON7059UNess Todd S · Thornton, CON70622Blizzard William J · Albuquerque, NMN7063EFantasy Balloon Flights Inc · Port Jervis, NYN7067MBeard Jeffrey M · Sedona, AZN70706Blue Moon Aviators LLC · Minocqua, WIN7076USanchez Ronald L · Albuquerque, NMN7078NHayes Melanie · Salt Lake City, UTN7080XSee Cookie M · Albuquerque, NMN7085LKelley Nicholas · Jeromesville, OHN7093NChieruzzi Maria R · Sparta, MON7096USewell Robert M · Reno, NVN7096VHooper Marclon M · Corpus Christi, TX
Back to AD 93-16-13