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.
N85NAHampden Aviation Services Inc · Northampton, MAN85NPSamayoa Rodolfo T · San Dimas, CAN85PWAnderson John C · Lake Geneva, WIN85QAmiculum LLC · Black Eagle, MTN85RGBolton William M · Waxahachie, TXN85RJTechnical Education Services Inc · Virginia Beach, VAN85RSQualitair LLC Trustee · MichelstadtN85RVKadlubowski Michael J · Colorado Springs, CON85RWJkg LLC · Murfreesboro, TNN85SBSnk Acft Enterprise LLC · O Brien, FLN85SDToledo Cowboys LLC (Mi) · Adrian, MIN85SPBurkett Jacob E · Polk City, FLN85TGWilliams Field LLC · Gig Harbor, WAN85TPCaruana Christopher M · Grand Island, NYN85TROdaniel Trey · Bennington, NEN85TTHerbert Henry W · Lake Stevens, WAN85TXBrown Judy C · Fredericksburg, TXN85TYYoung Thomas M · Homer, AKN85WABeckwith James N · Goldsboro, NCN85WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN85ZZSpeed Products LLC · Missoula, MTN8600DPockrus Pat B · Mineral Wells, TXN8600YMontcalm Kevin L · Mansfield, LAN8601AWhitaker Alvin E · Waterloo, WIN8601DRubbert Randy C · Reynolds, NDN8601NLpm Sky Masters LLC · Green Cove Springs, FLN8601WEtten Douglas E · Dalton, MNN8602DFithian Cody D · Wasilla, AKN8602KSkywagon LLC · Wilmington, DEN8602SBrodine Alan H · Rochester, NYN8603PComanche Flyers LLC · Jefferson Township, PAN8604WMoore Eric D · Elkhart, TXN8605DTroxel Robert G · Parma, IDN8605LMiller Andy D · Marana, AZN8605NTremper John D · Newton, NJN8605VGibney Ricky D · Fargo, NDN8605YFudenberg Elevated Solutions LLC · Las Vegas, NVN8606EJ&H Aviation LLC · Middletown, DEN8606PBuhler Carey C · Mitchell, SDN8607DDowns Benjamin S · Madison, SDN8607YMs Aero Inc · Lakeville, OHN8608DYoung Mike · Albany, CAN8608PLane Vaughn S · Gonzales, LAN8608VBenter Neil W · Ambrose, NDN8609NBird Properties LLC · Roosevelt, UTN8609WCherokee 8609w LLC · Morgan, UTN860ACAri Ben Aviator Inc · Fort Pierce, FLN860CPChristiansen Aviation LLC · Wilmington, DEN860DMC & C Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeN860PARe Elite Aviation LLC · Hialeah, FL
Back to AD 87-10-06 R1