AD 86-10-11 R1
Registered aircraft · 374
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:86-10-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-10-11-R1')
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:86-10-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-10-11-R1') 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.
N5089BSkycab Balloon Promotions Inc · Louisville, KYN5111CYoung Carl E · De Witt, IAN51267Stockley Don · Murray, UTN51371Balloonacy LLC · Fayetteville, GAN51417Green Kevin M · Gilmer, TXN51476Wheeler James H · Bryan, OHN51489Brielmann Kevin C · Cromwell, CTN51548Air Albert Lea · Albert Lea, MNN5156TPure Magic Balloon Team LLC · Bristol, WIN5185PBlackburn Jonathan C · Cottonwood Heights, UTN5231JLoesser Kenneth A · Annandale, NJN5236EMiller Michael J · Grafton, OHN5243JUtah Outventures LLC · South Salt Lake, UTN52455Bullock John W · Wausau, WIN52461Back Country Ballooning LLC · Tres Piedras, NMN52541Young Carl E · De Witt, IAN5254MFlying Circus Inc · Custer, SDN5258DFerrall Richard D · Lawrenceville, GAN5258MLutkus Janet · Medina, OHN5271ECamelot Balloons · Basalt, CON5274TNoel Benjie B · West Monroe, LAN5276RSproul Keith A · North Brunswick, NJN5276TWadsworth William · Albuquerque, NMN5277APhelan Jim E · Lincoln, ILN52826Johnson Amanda L · Prosser, WAN5282QAerostat Adventures LLC · Ormond Beach, FLN5284WOld World Balloonery LLC · Overland Park, KSN5285AChico Timothy G · Vista, CAN5289AAbove It All Balloon Co Inc · Basalt, CON5291VWillamette Aerostat Society · Albany, ORN52948Keller Environment Co Inc · Columbus, OHN53081Mcdevitt Daniel B · Galway, NYN5308NKramer David · Fort Edward, NYN5314ABrookside Ballooning LLC · Pennington, NJN53177Dakota Balloons LLC · Hot Spring, SDN53186Day Darrell · Rock Island, ILN54681Mcnabb Donald I · St Louis, MON54690Bubbles On Ash LLC · Tempe, AZN546WWBliss Outdoors Inc · Hemet, CAN5554CBaldock Tom · Ilion, NYN5555HJones 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, NJ
Back to AD 86-10-11 R1