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.
N5743VBohm David · Walnut Creek, CAN5744JLopresti Curtis · Vero Beach, FLN5748NShepard Scott D · Sanger, TXN574DMMelohn William C · Honolulu, HIN574JDNorton Mark H Trustee · Stateline, NVN5756KMoquin Thomas A · Hampshire, ILN5756VReneau Steven R · Houston, TXN5759BTjelle Michael J · Coal City, ILN575RWWashington County · Hillsboro, ORN5762HWeathers Scott M · Fort Worth, TXN57638Crabdree Marty D · Conroe, TXN57639Fox Larry D · Hinton, WVN5766PMid Pacific Aero Services LLC · Honolulu, HIN577EAQualitair LLC Trustee · MichelstadtN579GZEuroaviation Inc Trustee · KematenN579RCLavid Corp · Miami, FLN57CCavu Aviation LLC · Tulsa, OKN5806QLocke Charles T III · Darien, CTN5807VWhite Yvonne S · Lanham, MDN5807WZamora Cueva Jose Ruben · Boerne, TXN5808BRobinson Bevan LLC · Colorado Springs, CON5808FGf Air LLC · Las Vegas, NVN5808XDippolito Michael Mario · King Of Prussia, PAN580CDel Aviator LLC · Sea Bright, NJN58104Eddj Aviation LLC · Melfa, VAN58148Wilkerson James · Howell, MIN582CDLix Thomas A · Billings, MTN584PStoltenberg Jeffrey R · Brenham, TXN5876QJonesmont Air LLC · Taylor, AZN587NDPlane Fun Inc Tr Trustee · Snellville, GAN587RVMirarchi Joseph F · New Braunfels, TXN588MCPowell Jonathan M · Chattanooga, TNN5892VShadbolt George · Merriman, NEN58CSierra 1 Tech Inc · Blue Jay, CAN5906VL J L & D Inc · Wilmington, DEN5907VJ And K Flying Service Inc · Grand Island, NYN590DSouthern Aircraft Consultancy Inc Trustee · Casper, WYN591TASnappys Rotor & Wing LLC · Klamath Falls, ORN5920VMount Ptisi LLC · Winston Salem, NCN5925VMcgreevy Duane T · Spearfish, SDN59327Smith Steve W · Mackay, IDN5935VRzr Aviation LLC · South Jordan, UTN593RGAviation Trust Company LLC Trustee · Oklahoma City, OKN593SMorrison Neil E · Port Townsend, WAN594XMooney Frank X · Friendswood, TXN5959ACardinal 177b LLC · Bonita Springs, FLN5967VHinton Marie Catherine · Apple Valley, CAN5979FFly By Knight Inc · Hammond, LAN598DDDmd Associates LLC · Suffolk, VAN5996VM&M General Contractors Inc · Big Spring, TX
Back to AD 81-13-10 R1