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.
N8381YLehrer James Rodd · Thief River Falls, MNN8382PKutilek Emil J · Charlottesville, VAN8383PWhatley Mark · Orion, MIN8383YHolland Carl J · Dillsboro, INN8384PMauch Archie C · Magnolia, TXN8385YNesbitt Loyd B Jr · Independence, ORN8387YN8387y LLC · Huntsville, ALN8389PPower Joe D · Seguin, TXN8390PNordwick Thomas J · Uvalde, TXN8391PClare Enterprises LLC · Edina, MNN8392PVaughn Charles P · Inverness, FLN8392YTwinco Flyers LLC · Powell, OHN8393PMorrison Brian W · Zanesville, OHN8394PHilton Keith A · Galesville, WIN8396YPerkins Christopher R · Brackettville, TXN8398PBaca Andre · Albuquerque, NMN8399YHirschler Andre N · Goshen, INN83BWJohnson Nathan D · Pacheco, CAN8400PPiper Aviation Museum Foundation Inc · Lock Haven, PAN8401PPrecision Design Inc · Weatherford, OKN8403PNewell Douglas Bryon · Sedalia, MON8403YBlair Robert A · Red Bluff, CAN8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationN8405PCarlin Chad P · San Juan Capistron, CAN8405YBjorkman Marvin S · Richardson, TXN8406YPilgrim Robert C · Cape Coral, FLN8407YAwad Aviation LLC · Pooler, GAN8408PBeavers Jeffrey · Metairie, LAN8409PStevenson Gregory J · Sutter Creek, CAN8414PRudd Wayne · Basalt, CON8416YHenze Charles R · Waukee, IAN8417P250 Dash 4 Associates Ltd · Yellow Springs, OHN8418YHefner Joseph C · Mount Pleasant, TXN8419YMorrone Richard W · Westerly, RIN841PSLivin The Dream Aviation LLC · Jupiter, FLN8421PWills Terry W · Cedar Park, TXN8421YKesser Gilbert M · Culpeper, VAN8422PAnderson William · Creve Coeur, ILN8427YBiernacki David F · Rockford, ILN8428PBertling Kevin M · Spring, TXN8430YDavid Litteken · Aviston, ILN8431YN8431y LLC · Coatesville, INN8432YTaylor Kyle F · Enterprise, ALN8435YGlobal Aviators Academy Inc · Claremont, CAN8438PCrews Cobert J · Shady Shores, TXN843DCJuliet Echo LLC · Sheridan, WYN843GR & B Aircraft Holdings LLC · Denham Springs, LAN8440PSpoor John B · Sandwich, ILN8441AAerolease LLC · Wilmington, DEN8443PLeggett Marjy A · Pasco, WA
Back to AD 77-13-21