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.
N5555HJones Chris M · Amarillo, TXN5557NSchreiber-Beck Cynthia K · Wahpeton, NDN5560NDigiovanni Ronald · Milford, NJN55611Marti Roy W · Naples, FLN5562KMinnetonka Balloon Co Inc · Chanhassen, MNN5562RKimmich Russ S · Coronado, CAN5563LArman Marcelo A · San Diego, CAN5563NKornfield Edward Alan · Anchorage, AKN55647Davis John C IV · Evergreen, CON5572AJd Adventures LLC · Piscataway, NJN5673NHannibal Robert A · Topeka, KSN5682DZimmitti Kaitlyn J · Monument, CON5683BSorensen Christopher · College Ward, UTN57030Lesmeister Michael A · Rochester, MNN5707DSproul Keith A · North Brunswick, NJN57103Massey Lee M · Somerset, WIN5716NBauer William S · Ona, WVN5716YRobinson David G · Half Moon Bay, CAN5717HAero Electric Inc · Boulder City, NVFirst renewal noticeN57194Nilz Patrick · Tucson, AZN5724ASnow Richard H · Deer Trail, CON5895Churchman Harrison · Mcdonough, GAN5MMLincicome Michael T · Livermore, CAN614JRBalloons Over Westchester LLC · Bedford, NYN616BGHigher Reach LLC · Meridian, IDN623KLWahl John · Edgewood, NMN62CTBrossett Gary M · Columbus, GAN63004Hoefler Construction Inc · Albuquerque, NMN6301URightley Paul · Albuquerque, NMN63032Habetz Tedmund D · New Iberia, LAN63044Karl Patrick · Montville, OHN6305VKenerson Joseph W · Prairie Grove, ARN6307QRoller Billy E · Lubbock, TXN6309PSproul Keith A · North Brunswick, NJN63107Old Style Saloon No 10 · Deadwood, SDN6312ROld World Balloonery LLC · Overland Park, KSN6312UAir Ventures Balloon Rides Inc · Chester Springs, PAN6313AWeiner Carol A · Fairlawn, OHN6314QTerranova Ronald M · Hamilton, OHN6314UHowland Alan R · Zachary, LAN63158Mueller Sheila K · Evans City, PAN63162Young Deborah L · Box Elder, SDN6316COzvat Matthew D · Windsor, CON6316LLafleur Robert B · Fitchburg, MAN63178Williams Rodney L · Branson, MON6317SRaper Robert B · North Bend, ORN63196Ulrich Meredith R · Fenton, MIFirst renewal noticeN6319SMountain West Aeronauts · Custer, SDN6320WBredbenner Carl · Dalmatia, PAN6322XSalazar Katelyn C · Los Lunas, NM
Back to AD 93-16-13