AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N9246JMckool John Jr · Johnstown, PAN9246KN9246k Corp LLC · Federal Way, WAFirst renewal noticeN9246MShenkirsch Consulting Inc · Mammoth Lakes, CAN9246PSharp Paul C · Modesto, CAN9246VBibbs Kevin · Copperas Cove, TXN92471Shoemaker Floyd · Oneida, TNN9247DLaw C Scott · Oklahoma City, OKN9247ELeigh William L · Minonk, ILN9247JGreco Timothy F · Sewell, NJN9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN9247PEhrenberg David G · Corning, NYN9247YWest Bend Air Inc · West Bend, WIN9248KGerstner Michael J · Ola, ARN9248MTaylor Douglas W · Tucson, AZN9248PPajaro Jaison · Burtonsville, MDN9248VBoardman Thomas M · Greenwich, NYN9248WMeyers Andrew W · San Ramon, CAN9249EThomas Howard M · Hernando, MSN9249HGencur Paul A · Hudson, OHN9249MMaverick Aviation LLC · Richmond, KYN9249VRobertson Scot H · Tribune, KSN924CCSky West Aviation Inc Trustee · Albuquerque, NMN924CSBeinhauer Emerson R · Naperville, ILN924DLester Christopher J · Vancouver, WAN924DBFlying Veterans Club Of San Francisco Inc · Belmont, CAN924DCAirmann Leasing LLC · Mount Sterling, KYN924DMSmoketown Helicopters LLC · Smoketown, PAN924DWLive Free And Fly Hard LLC · Santa Cruz, CAN924EIzzard William S · Crescent City, FLN924JHSmith Nigel A · Winona, MNN924JLGross John L · Carthage, MSN924JPProck Jack A · Auburn, CAN924JWStephenson James M Jr · Hyampom, CAN924KAEvanoff Mark Alan · Saint Augustine, FLN924MCJ Airco LLC · Nashville, TNN924NDUniversity Of North Dakota · Grand Forks, NDN924PLWilliamson Jay S · Phoenix, AZN924RRHigh Timothy Duane · Glenwood, MON924SHHillsboro Aero Academy LLC · Hillsboro, ORN924SJRickets And Associates LLC · Ardmore, OKN924TEPlyler Robert S · Spring, TXN924TFRegistered aircraftN92500Romeo Charlie Aviation LLC · Stuart, FLN92505Thunderbird Aviation Inc · Bloomington, MNN9250CRegion Flyers LLC · Valparaiso, INN9250DJouflas Nikos A · Anchorage, AKN9250PBas Part Sales LLC · Greeley, CON92511Mckay Donald A · Soldotna, AKN9251EArrowpoint Investments LLC · Mountain Brk, ALN9251JGholami Amir K · Santa Rosa, CA
Back to AD 87-10-06 R1