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.
N70979Cato Amie D · Paris, TXN7097AFenster Matthew · Bellevue, NEN7097BLight Flight Balloons Inc · Bel Air, MDN7097ESproul Keith A · North Brunswick, NJN7097FWilliams Garrett J · Sioux Falls, SDN7097HJones Michael A · Omaha, NEN7097JRagsdale William C II · Colorado Springs, CON7097KAugustad Alex · Sioux Falls, SDN7097UStewart Laura R · Decatur, ALN7097YBlucher Stephen · Colorado Springs, CON70989Sturge Gregory R · Tulsa, OKN7098HGastrich Tom F · Wasilla, AKN7098XHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTN7098YLong Edgar E · Lake Alfred, FLN7099HMichigan Hot Air Adventures · Howell, MIFirst renewal noticeN7099SRegistered aircraftN7099UUrbanovsky Michael R · Statesboro, GAN71072Matney Dallas L · Sparta, MON71096Davison Associates Inc · Phoenix, AZN7111GJones Christopher J · Billings, MTN71150Barnes Laura J · Oconomowoc, WIN7118ASally T Ware · Salt Lake City, UTN7118FGordon Edward G · Austin, TXN7119TStreeter Jack T · Blaine, MNN711EFThornton Floyd R · Saint Louis, MON7120MCitadel Communications Corp · Albuquerque, NMFirst renewal noticeN7121KSchuler Nolan P · Manitou Springs, CON7123YAerial Adventures LLC · Burton, OHN7126YRobison William M · Fort Worth, TXN71280Oliviann Balloons LLC · Hodgenville, KYN7128JHelstrom-Hanley Cheri A · Summerdale, ALN7129VMezey Robert · Parrish, FLN7130QMason James J · Albuquerque, NMN7132ASmith Brann K · Chico, CAN7132KGonzales Michael O · Albuquerque, NMFirst renewal noticeN7132XHelmuth Dennis · Wooster, OHN71330Mccourt Kimberly Royal · Winter Haven, FLN7133URiehle Jacob P · Johnston, IAN7134ARobison William M · Fort Worth, TXN7134SNilz Patrick S · Marana, AZN71383Winder Jimmy Dean · Bristol, WIN7138HBackes Daniel A · Florence, AZN71394Korth Brandon C · New London, WIN7139FHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTN7139NChurchman Mark A · Lebanon, TNN7139RThomas Nancy P · ChallesNon-citizen corporation, flight hours not reportedN713DCKrieg Carole L · Independence, ORN71410Stewart Laura R · Decatur, ALN71415La Lorraine Enterprises · Albuquerque, NMN71423Balloon The Rockies Inc · Park City, UT
Back to AD 93-16-13