AD 81-21-02 R1
Registered aircraft · 366
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:81-21-02-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:81-21-02-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:81-21-02-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:81-21-02-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.
N5111CYoung 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, OHN52455Bullock John W · Wausau, WIN52541Young Carl E · De Witt, IAN5258DFerrall Richard D · Lawrenceville, GAN5258MLutkus Janet · Medina, OHN5274TNoel 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, NJN5673NHannibal Robert A · Topeka, KSN57030Lesmeister Michael A · Rochester, MNN5707DSproul Keith A · North Brunswick, NJN57103Massey Lee M · Somerset, WIN5716NBauer William S · Ona, WV
Back to AD 81-21-02 R1