AD 81-13-10 R1
Registered aircraft · 4,001
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-13-10-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-13-10-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-13-10-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-13-10-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.
N262AKKempton Alan R · Lutz, FLN262BBFive Four November Inc · Littleton, CON262CMyers Thomas · Hot Springs, ARN262CDSig Awy Inc Trustee · Wilmington, DEN262EZN262ez LLC · Canton, OHN262GMRochester Air Center LLC · Canandaigua, NYN262JKPeachtree Aviation Inc · Woodstock, GAN262MBMurray Adventures LLC · Dallas, TXN262MPSky West Aviation Inc Trustee · Albuquerque, NMN262RVT & J Air LLC · Wilmington, DEN262RWMakino Kazuya · Fountain Valley, CAN262VFBaker Geoffrey D · Philomath, ORN262WDWyoming Development LLC · Cheyenne, WYN262WEN262we LLC · Akron, OHN2630SDuquette Stephen R · Fenton, MIN2632SAvialogia Inc · Wilmington, DEN2633SAir Apparent LLC · Santa Rosa, CAFirst renewal noticeN263CDHayon Ilan · Oakland Park, FLN263DBZulu Murphy LLC · Oklahoma City, OKN263HBTakahashi Hector · Livingston, NJN2645SVenice Group LLC · Hopkinton, NHN2648SRegistration Pending · Albuquerque, NMRegistration pendingN265E&S Management LLC · Miami, FLN2651VHagl Aviation LLC · Sunray, TXN2657S57 Sierra LLC · Houston, TXN2663SMaclean Kenneth J · Northborough, MAN2664SMcclain Daniel S · Enon Valley, PAN2666SHageness Hartley · Rugby, NDN2669SWilliams Kent A Jr · Kissimmee, FLN266RVHuelskamp Thomas L · Fowler, KSN2672SJja Transportation LLC · Springville, UTN2679SJordan Richard L · Memphis, TNN267CDTsp Aviation LLC · North Fort Myers, FLN267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEN2684VReims Rocket LLC · Tempe, AZN268ACPafford David A · Floydada, TXN2694CCranford Billy J · Wasilla, AKN2694SMock Joseph R · Huntsville, TXN2698MBearce Larry James Jr · Solon, IAN269CDMclaughlin John · Palm Harbor, FLN26PHHuff Peter C · Mckinney, TXN2704VVorderbruggen Gary J · Garden Valley, CAN2706ESj Construction Group LLC · New Berlin, ILN2711YAnn Arbor Air LLC · Plymouth, MIN2719CBrown Kevin Charles · Round Rock, TXN2744MCas Aviation LLC · Warwick, RIN2751MWktr Inc · Cocoa Beach, FLN275CDTyler John G IV · Sandy, UTN275RSMonaco Aviation LLC · Duluth, MNN276DBN276db LLC · Mesa, AZ
Back to AD 81-13-10 R1