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.
N3040WLay Camillius C · Helena, MTN3048Speck Michael A · Friendswood, TXN3048YAeronautica LLC · West Hollywood, CAN304MADodson International Parts Inc · Rantoul, KSN304XStone John Brody · Birmingham, ALN3051XWagner Richard L · Conroe, TXN3052QBinning Marlin R · Grand River, IAFirst renewal noticeN3054KFerguson David G · Woodbridge, VAN3057NWhite Brian M · Lindenhurst, NYN3057VBig H Transportation LLC · Traverse City, MIN305BKRegistration Pending · Delta, OHRegistration pendingN305GTomahawk Aviation LLC · Reno, NVN305GDGlyn Dwr Air LLC · Kalispell, MTN305GGChayes Daniel A · Mercersburg, PAN305HStat Care Clinics LLC · Baton Rouge, LAN305JBKoning Ryan W · Williams, AZN305JKOrcutt John Edward · Tucson, AZN305KFlorida Flying Tigers LLC · Tampa, FLN305KMKeim Jeffrey R · Moorhead, MNN305L305l Air Holdings LLC · Phoenix, AZN305LSHill Karin V · Georgetown, TXN305MKCoughlin Enterprises Inc · Central Point, ORN305NHRoesch John M · Largo, FLN305PE305pe LLC · Lakewood Ranch, FLN305PRGlahn Guy R · Redmond, ORN305REasterling William D · Salisbury, NCN305RMPuglielli Jeffrey W · Bolingbrook, ILN305RTMorris Alysse · Rapid City, SDN305SESouthern Aircraft Consultancy Inc Trustee · Casper, WYN305XWallitner Aviation & Restoration LLC · Bremerton, WAN3060TPalumbo Henry R · Novato, CAN30619Wrpl LLC · Mountain Brk, ALN3061TAdventure Lab Aviation LLC · Saint George, UTN3063NConstantinides Chris · Chula Vista, CAN30640Christianson Cleet M · Enumclaw, WAN3068QTurbo Arrow IV LLC · Nibley, UTN3070ZGarber Greg · Redmond, ORN3071NBunkie Bird LLC · Tucson, AZN3072XParsons Keir Wurzel D · Naples, IDN3073MRobinson Robert F G · Round Rock, TXN30746Tribe Of Judah Motorcycle Ministries Inc · Humble, TXN307TKReim Rodney D · Enid, OKN3084QHibbard Paul A · Mountain Home, IDN3089UCharles T Crinnian Md Pc · Phoenix, AZN308MARegistered aircraftN3090QLarsen Wayne C · Tremonton, UTN309XBernacki David A · Clyo, GAN30AAOcean Lighthouse LLC · Central, SCN30GPCedar Mountain Respiratory Inc · Athol, IDN30STennessee Technology Center At Morristown · Morristown, TN
Back to AD 81-13-10 R1