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.
N5283UCowlishaw Brenda L · Bulverde, TXN5284WOld World Balloonery LLC · Overland Park, KSN5285AChico Timothy G · Vista, CAN5285MMarketing Services Inc Of Pueblo · Colorado Springs, CON52867Post Employees Balloon Club Inc · Battle Creek, MIN52869Corcoran Levi J · Garland, TXFirst renewal noticeN5286XDuer Balloons And Promotions Inc · Warr Acres, OKN5287JHicks Albert B Jr · Griffin, GAN5289AAbove It All Balloon Co Inc · Basalt, CON5289YGingerich Joseph · Plain City, OHN52917Burr Thaddeus E · Southbury, CTFirst renewal noticeN5291VWillamette Aerostat Society · Albany, ORN5292BWilson Petra · Hot Springs, SDN52935Stewart Karen · Sinclair, MEN52943Van Dyck Chris · Albuquerque, NMN52948Keller Environment Co Inc · Columbus, OHN5294QSkyline Hot Air Balloons LLC · Fishers, INN5294VIrwin Patrick S · Lovelock, NVN52965Dreams Aloft · Rochester, MNN5296LLight Flight Balloons Inc · Bel Air, MDN52972Registered aircraftN52973Spa And Pool Doctor LLC · Goshen, KYN5298BDill Cooper M · Lake Tapps, WAN5299JOlin Michael A · Warner, NHN5299VBlue Ridge Balloon LLC · Palmyra, VAN5303CGunderson John H · Irene, SDFirst renewal noticeN5305MEwer Daniel W · Tucson, AZN5305YLewis John R · Leakey, TXN5306THjorth Garret P · Spanish Fork, UTN53081Mcdevitt Daniel B · Galway, NYN5308NKramer David · Fort Edward, NYN5312EBalloons Of Vermont LLC · Quechee, VTN5313SMcclurg Elizabeth A · Ashland, OHN53145D C G & Assoc Inc · Rio Rancho, NMN5314ABrookside Ballooning LLC · Pennington, NJN5314UBrenner Barney · Tucson, AZN5314ZRegistration Pending · Tucson, AZRegistration pendingN5315MDespres Denise · Cedar Crest, NMN53167Davis Bryan · Albuquerque, NMN53177Dakota Balloons LLC · Hot Spring, SDN5317GRobison William Matthew · Fort Worth, TXN5317LEndeavor Aviation Inc · Belgrade, MTN53186Day Darrell · Rock Island, ILN545LBColumbine Animal Hospital Inc · Littleton, CON54681Mcnabb Donald I · St Louis, MON54690Bubbles On Ash LLC · Tempe, AZN546WWBliss Outdoors Inc · Hemet, CAN54NBHelberg Donald A · Orange City, FLN5554CBaldock Tom · Ilion, NYN5555EPye Houston W · Cloudcroft, NM
Back to AD 93-16-13