AD 94-05-05 R1
Registered aircraft · 26,228
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N10982Burris Kye A · Gillett, ARN10992Totm Holdings LLC · Harbor Springs, MIN10993Bryant Lyle W · Ellinwood, KSN10996Coughlin Edward L · Cazenovia, NYN1099HTzenis Michael · Lakeville, MNN109SCCobb Lee C · Van Alstyne, TXN10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDN10BCYaberg Thomas L · Rosamond, CAN10BFCruz Keoni K · The Woodlands, TXN10FPLoves Park Air LLC · Loves Park, ILN10GSMaye Darren Alvaro · Jacksonville, FLN10KSMorris Jerry M · Summerville, SCN10MJHocker James L · Brookville, OHN10RHGoodson David · Millbrook, ALN10TLMoore Allan D · Palm Coast, FLN10XSWittman Flying Service · Ripon, WIN10ZRRitter Douglas D · Colorado Springs, CON1100Souchet Brian · Fleming Island, FLN1100SHagen Johnny D · Claremore, OKN11018Jepsen Dorian B · Selah, WAN11022Tailwheel Solutions LLC · Wilmington, DEN11023Kyser Donald J · St Paul, MNN11025Edmunds Brenda L · Tallahassee, FLN11026Allen David L · Surfside Beach, SCN11028Rush Casey K · Troy, KSN11029Benner James M · Great Falls, MTN1102FGrant County State Bank · Carson, NDN1102YSass James Louis Jr · Abilene, TXN1103Schmidt Thomas P · Nunica, MIN11031Griffin Brian · Nashville, GAN11033Keller Lee J · Minot, NDN1103DOber John A · Candor, NYN11041Quad Aviation LLC · Branchville, NJN11042Hogsten-Anderson Niklas Erik · Jupiter, FLN11049Pancake C William Jr · Keyser, WVN1104DRymill Mark R · Belmont, CAN1104FMiller Jonathan A · Apo, APN11052Prather Carl Lynn · Gilroy, CAN11053Skaggs Zachery · Bono, ARN11055Graham Bruce Edwin · Coto De Caza, CAN11059Lakes Area Aviation LLC · Little Falls, MNN1105DGilman Larry E · Reno, NVN1105FGibbard Donald R · Walla Walla, WAN1105HMaya Aviation LLC · Lee, NHN11062Sullivan Lynford M · Hernando, MSN11065Bishop Dean D · Dexter, MON11066Stick N Rudder LLC · Cartersville, GAN11067Teel Glen A · Hays, KSN1106DMurdock Mark F · Ketchikan, AKN1106TPierce John R · Hulett, WY
Back to AD 94-05-05 R1