AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N8329YHarbock Inc · Wilmington, DEN8331PBurbanks Travis R · Tarzana, CAN8331YFeit Paul · Osprey, FLN8332PGray James Gary · Simpsonville, SCN8333PAllred Klein Enterprise LLC · San Diego, CAN8336PWyatt Gary D · Sun City West, AZN8336YPatterson Thomas A · Minerva, OHN8337YBorden William · Commerce Township, MIN8338PHerndon Properties LLC · Walterboro, SCN8339YBas Part Sales LLC · Greeley, CON833DFAirdorrin Inc · New Castle, DEN8340PChristiansen Lance W · Anacortes, WAN8341PLife Is Flying Inc · Deerfield Beach, FLN8341YPepper Dale D · Newnan, GAN8342PGibbs Randy Shane · Louisburg, NCN8343YSpector Steven D · Glenview, ILN8344PGulledge Richard · Deland, FLN8345PMcgough Christopher M Trustee · Hurricane, UTN8346PPhelps Michael J Trustee · Oneida, TNN8348PEchols Mark R · Diana, TXN8348YNelson Brian · Wakefield, NEN8349PPickett Douglas M · Romeo, MIN8351PComanche Air Holdings LLC · Austin, TXN8352YSkylandsair LLC · Port Orange, FLN8353YSoutheast Leasing LLC · Delray Beach, FLN8355PSutliff Larrie G · Briarcliff Manor, NYN8356PEarl Tim G · Plymouth, CAN8357PHames David W · Amarillo, TXN8358YGruenbaum Michael S · Eastvale, CAN8359YManyak Louis J · Inglis, FLN8364PSheeree Corp · Wilmington, DEN8365PHanna James L · Simi Valley, CAN8365YTwin Time LLC · Battle Lake, MNN8366PBurris Robert V · Charlotte, NCN8366YLieberman Bill A · Port Orange, FLN8368PBoyko Michele A · Albuquerque, NMN8368YMeadows Michael M · Cypress, TXN8369PLeenhouts John R · Mulberry, FLN8370PDonovan Patrick D · Troy, MON8371YAstro Star Aviation Inc · Niles, MIN8373PZeller Ryan P · Reno, NVN8375PGores Thomas J · Franklin, WIN8375YSimmons John William · Ocala, FLN8376YScharfenberg Charles · Maquon, ILN8377PGullett Samuel H · Lafayette, LAN8378PBel-Aire Home Restoration LLC · Platteville, WIN8378YEmerald Aircraft LLC · Greenwood, SCN8379YSpaeth Alexander H · Aurora, ILN837PGG & G Comanche LLC · Magnolia Springs, ALN8381PIndy Air Sales LLC · Anderson, IN
Back to AD 77-13-21