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.
N90861Cheatham Laurie · La Verne, CAN9088MFaber Jeffrey A · Holland, MIN9093NChurchman Elijah Tucker · Mcdonough, GAN9094MSproul Keith A · North Brunswick, NJN90952Bennett James S · Louisville, KYN90954Smith William N · Canton, OHN90958Bryant Sandra J · Sacramento, CAN9095LErwin Keith S · Milford, NJN9095NMiller Michael · Grafton, OHN9096ABiernacki Buzz · Albuquerque, NMN9096UClemons Louise DBA · Truro, IAN9096YClark J Stanley · Pewee Valley, KYN90978Spanier Thomas L · Rogers, MNN9097EBauwens Michael G · Park City, UTN9097SCampbell James N · Ashland, ORFirst renewal noticeN90980Scherm Peter J · Kennesaw, GAN9098TJones Rebecca H · Preston Park, PAN9098YFlyjuno LLC · Jupiter, FLN90999Ewer Dan W · Tucson, AZN9099FHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTN9099USommers Christopher A · Slatington, PAN90KZFarzad Dariush · Willseyville, NYN90XLOliviann Balloons LLC · Hodgenville, KYN91008Alexandria Balloon Flights · Milford, NJN9100GChurchman Mark A · Lebanon, TNN9100QMuir Allan K · Houston, TXN9100XPrairie Sky Inc · Custer, SDN9101SPeterson Deborah · Euless, TXN9102NNilz Raymond P · Tucson, AZN9102UKeown Owen B · Temecula, CAN9103SCox Jordan R · Carmel, INN9103YSproul Keith A · North Brunswick, NJN91057Stumpf Paul S · Andover, VTN9105E605 Balloon Ride LLC · Sioux Falls, SDN9105UHigh Plains Drifter Hot Air Balloons LLC · Miles City, MTN9106QJaworski Adam C · Omaha, NEN9107NConnell David D · Las Vegas, NVN91081Sturge Gregory R · Tulsa, OKN91082Childers Dane J · Tanner, ALN91086Plains National Bank · Lubbock, TXN9108FRogers Carol M · Tallahassee, FLN9110BRainbow Ryders Inc · Albuquerque, NMN9110RConley Jeffrey A · Upper Sandusky, OHN91123Registration Pending · Sioux Falls, SDRegistration pendingN91128Eldridge Stacy D · Rio Rancho, NMN9112FHustler James E · Carson City, NVN9113HOlivier Orvin E Trustee · Sioux Falls, SDN91164Tagtow Debbie D · Rock, KSN9117NSmith Jo E · Arkport, NYN9118XMellon Sam A III · Oxford, AL
Back to AD 93-16-13