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.
N9495VSoccer Goals LLC · Christoval, TXN9496DCavu Clearing LLC · Center Harbor, NHN9496VEvans Richard I · Elko, NVN9496WJones Terry · Bells, TNN9497JShushnar Gary J · Irvine, CAN9497PRegistration Pending · Summerville, SCRegistration pendingN9498JBrantley Hugh L · Hazlehurst, GAN9498KDirksen Caleb A · Garner, IAN9498LRaber Jonathan L · Baltimore, MDN9498NKoehler Scott A · Brighton, ILN9498VMoonshiner Aviation LLC · Austin, TXN9499BWyatt Bradley S · Bishop, CAN9499NFlight Niner Niner LLC · Charleston, SCN9499VBerliner Donald D · Medford, NJN9499ZDark Sky Enterprises LLC · Flagstaff, AZN949BVStout Billy V · Hooker, OKN949CDDupont Samuel F C · Mount Solon, VAN949GCareer Pilot Training LLC · Wilmington, DEN949MRivera Justin J · Orlando, FLFirst renewal noticeN949MDUnruh Leasing LLC · Blossom, TXN949PHedgpeth Richard L · Evergreen, NCN949PWMcphillips Flying Service Inc DBA · Beaver Island, MIN949RVVan Wagenen Stanley Keith Trustee · Las Vegas, NVN949SMAviation Trust Co LLC Trustee · Oklahoma City, OKN949SPN949sp LLC · California, MDN949TEBarron Wesley Thomas · Port Orange, FLN949TSSmith Emmet Q · Portola, CAN949TTAero Optics Inc · Aguila, AZN949WParrish Shawn J · Great Falls, MTN949WAP S S Air Inc · Middlesboro, KYN949WCCampbell Weldon W · Great Bend, KSN949WRMurley Kent K · Sequim, WAN94AAPhillabaum Stephen D · Deer Park, WAN94ABMiller Paul · El Dorado Springs, MON94AGSimmons Mark A DBA · Pawcatuck, CTN94AKWestern Aviation LLC · Bloomfield, MIN94AXJudd Howard C · Tehachapi, CAN94BDMcelwain Russell D · Lancaster, KSN94BNRegistered aircraftN94BSMcdonnell John T · Yardley, PAN94CLEasterbrooks Paul · Chesapeake, VAN94CPAhlhorn Travis Wayne · New Braunfels, TXN94CRGilbert Michael John · Louisville, KYN94DRegistered aircraftN94DBFox Joseph L · Ocean City, NJN94DFBesa Aircraft Corp · Lafayette Hill, PAN94DGGreen Daryl K · Grove City, OHN94DLWhiskey November Aviation LLC · Minneapolis, MNN94DTInternational Air Services Inc Trustee · Carson City, NVN94DWTracy David B · West Haven, UT
Back to AD 87-10-06 R1