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.
N6323URegistered aircraftN6327GPortland Rose Balloons LLC · Wilsonville, ORN6328URadowski Johnathan P · Phoenix, AZN6328WBrown Charles S Jr · Mount Washington, KYN6328ZCt Ballooning LLC · Kensington, CTN6331QPolston Derald L · Farmington, NMN63335Brandon Zachary T · Winneconne, WIN6333UOchsner Perry W · Dilworth, MNN6335AKominiak Scott A · Corrales, NMN6335DPyron Brigham Asbury · Smyrna, GAN6335NKeaveny Robert M III · Albuquerque, NMN6335PBartra Alejandro M · Rio Rancho, NMN6336CRobertson Stanley D · Carson City, NVN6336GHarrison Kenneth E · Redondo Beach, CAN6336HZavatsky Gregory D DBA · Northridge, CAN6337YBubbles On Ash LLC · Tempe, AZN6339FHays Stephen Craig · Coppell, TXN6339GGowing Glyn T · Longview, TXN63402Chavez David R · Artesia, NMN6341UMccammon Zach James · Roswell, GAN6341VFuller David M II · Saint Augustine, FLN6343HMooney Mollykate · Woodbury, CTN6343MLighter Than Air America Inc · Boise, IDN6343RDakota Balloons LLC · Hot Springs, SDN6345USmith Edward C · Lecompton, KSN6347YSharpee Thomas Ross · Brandon, SDN63484Portland Rose Balloons LLC · Wilsonville, ORN6348XLight Flight Balloons Inc · Street, MDN6348ZWarren Alan W · Waterford, MIN63498Vereb Frederick P · Tampa, FLN6349XKrause Shawn L · Zachary, LAN6349YReiger Virginia J · Sheridan, WYN6350CFear Darrell E · Artesia, NMN6350YConrad Kenneth J · Albuquerque, NMN63528Light Flight Balloons Inc · Whiteford, MDN6352ASullivan Amanda · Rio Rancho, NMN6352DMcdonald Daniel J · Whitehouse Station, NJN6353SClark Brian A · Lexington, OKN6353TBalloon Quest Inc · Fenton, MIN6355GHoge Peyton H · Louisville, KYN6356PPluta Mark C · Saratoga Springs, NYN6356WHudson Seth D · College Station, TXN63571Palmer Gerald R · Albuquerque, NMN6357JAwaiting Inflation Ballooning LLC · Columbus, INN6358YRegistration Pending · Natchez, MSRegistration pendingN6359EBalloon Talk LLC · Bloomfield, NJN63603Nj Tech Medics LLC · Neshanic Station, NJN63625Schwemmer Kasey R · Indianola, IAN63636Rodriguez Tina M · Southington, CTN6363FBueno Thomas J · Albuquerque, NM
Back to AD 93-16-13