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.
N897RVPorter David T · Martinsburg, WVN897SCPeregrine Howard Partners II Lp · New Orleans, LAN8980PLittle Wood LLC · Bellevue, MIN8980RHolmes Aviation Inc · Cannon Falls, MNN8980VSweitz-Air Inc · Stewartstown, PAN8980WAddis Timothy David · Mount Vernon, OHN8980YTomu Fly LLC · Vero Beach, FLN89811Sky Warrior Flight Training Inc · Pensacola, FLN8981AAmerican Aircraft Sales LLC · Lincolnshire, ILN8981RBlock Raymond J · Palmer, AKN8981YGrey Enterprises Holdings LLC · Kalispell, MTN8982DNorth Sound Aviation Inc · Sedro Woolley, WAN8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZN8982RBoo Steven R · Chisago City, MNN8982VHirsch John K Trustee · Gerald, MON8982WTorres Lewis A · Pasadena, CAN8982YCovington James P · Poplar Grove, ILN8983JStensrud Maynard R · Waseca, MNN8983PBlum Kenneth J · Truckee, CAN8983VMoon Reagan E · Bossier City, LAN8984JKlassen Wayne V · New Ulm, MNN8984NBlair Gary B · Salado, TXN8984PMarchant Scott · Clackamas, ORN8985CCornelius James Sean · Hamilton, MON8985PSharp Charles Barry · Fulton, KYN8985WKeskintepe Levent · Las Vegas, NVN8986JKleinberg Kenneth A · Saugerties, NYN8986NBay Air Inc · Dillingham, AKN8986PNielsen James R · Carson City, NVN8986RYarbanton John Robert · Muskegon, MIN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN8986WCandler Derrick · Tampa, FLN89878Corwin Shawn M · Tucson, AZN8987CDouble M Charters LLC · Lakeland, FLN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN8987WSonrise Aviation LLC · Lake Havasu City, AZN8987YHanson William D · Soldotna, AKN8988JMerkle Hunter T · Mattawa, WAN8988NCicero Flying Club LLC · Indianapolis, INN8988RYoung Andrew J · Eagle River, AKN8988VWahle Daniel C · Missoula, MTN8988WGonzaga Michaelr · Chino Hills, CAN8989JJohnston Family Clinic Inc · Meridian, MSN8989XCascadia Aircraft LLC · Sandpoint, IDN898AMWyatt LLC · Hot Springs, SDN898CPThomas Robert M Jr · Kissimmee, FLN898DANopat LLC · North Charleston, SCN898DKPratt Christopher J · Dallas, TXN898DSBeretta James P · Indian Springs, ALN898GAtp Aircraft 9 LLC · Wilmington, DE
Back to AD 87-10-06 R1