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.
N208LGAnson Douglas M · Dripping Springs, TXN2091VAircraft Partners LLC · Owensboro, KYN20947Williams Harry D III · Frostproof, FLN2094VCorning James Elmon · Flagstaff, AZN2095VMoon Christopher · Guyton, GAN2096XSeward Mark · Seattle, WAN20CNuxoll Randy G · Eagle, IDN20CDCording Christopher Robert · Wendell, NCN20CVRoss Craig L · New Castle, DEN20JXWorld Wide Air & Sea Inc · Wilton, NHN20RNOlive Aviation LLC · Anchorage, AKN20VRJefferies Wayne · Durango, CON20WJDiversified Air Services LLC · Edmond, OKN20WSEmmer Michael Harold II · Aiken, SCN20XKBuildings Evergreen LLC · Bismarck, NDN2100XSchwind Michael K · Dublin, OHN2104ZZukauskas Girenas · Naperville, ILN2106EBas Part Sales LLC · Greeley, CON2106ZC & E Aviation LLC · Lewes, DEN210BLGraham Mark Allan · Anchorage, AKN210GClear Prop LLC · Kalispell, MTN210HKConway Jenna Marie Wells · Camarillo, CAN2110YFlying Colors Airparts Inc · Leesburg, FLN2113MEli Engineering & Manufacturing · Merrillville, INN2114K Heart Aviation LLC · Choudrant, LAN2114MKilo Delta Force LLC · Visalia, CAN21160N21160 LLC · Sanford, FLN2118HMcfadden Derek C · Lebanon, OHN2118TMein-Bar Inc · Pittsburgh, PAN2119CClakley Gordon Nathan · Clayton, CAN211DCN211dc LLC · Los Angeles, CAN211EWJtb Logistics LLC · Byars, OKN2121VOvcc Flyboys LLC · Tucson, AZN2122QGold Coast Flight Service LLC · Camarillo, CAN2125XMathews Wade · Wichita Falls, TXN2126UBates Judith J · Waquoit, MAN2127KLee Bruce W · Strasburg, CON21299L-Bird LLC · Hood River, ORN212LVN212 Holdings Llp · Camden, DEN212MLSeneca Aviation Inc · Wilmington, DEN2130KQualitair LLC Trustee · MichelstadtN2130UZadora-Przylecki Karol · Sammamish, WAN2131XBrown Jerry D · Rockport, TXN2134NPainter Christopher R · Castle Rock, CON21353Elm Aviation LLC · Norfolk, VAN2136PTrebbow Mike A · Santa Barbara, CAN21382Rodriguez Carlos Mendoza · Paramount, CAN21387Kramer Kent M · New Braunfels, TXN2138XSpencer Douglas J · Greenwood, CAN2139XAerometrix LLC · Lino Lakes, MN
Back to AD 81-13-10 R1