AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N9908HKoch Vincent Karl · Canyon Lake, CAN9908VDls Computer Services Inc · Lake In The Hills, ILN9909NMorgan Vernon E · Dillon, CON9909QCk Aviation LLC · Charlestown, INN9909XMameli Tyler L · Williamson, GAN9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKN990BFlight Academy LLC · Van Nuys, CAN990CAJundi Adam · North Royalton, OHN990CKSaucier Christopher A · Marion, MTN990USimpson Reed · Marco Island, FLN990VPValenzuela Pedro · Douglas, AZN990WPThomas Field Flying Club LLC · Holly Springs, MSN99100Sterling Flight Training LLC · Jacksonville, FLN99104Dury Aviation Services Inc · De Soto, ILN9910ABach Jeremy · Camp Verde, AZN9910ESmoke Eagles Inc · Newport Beach, CAN9910MSatran Paul C · Detroit Lakes, MNN9910NRunner Douglas A · Ashby, NEN9910QTevebaugh Dennis J · Elkhart, KSN9910XHower Loyal L · Moscow, IDN9911ADaniels Bayce D · Anthony, NMN9911BGustafson Kim · Lake Stevens, WAN9911HDouglas Forest Protective Association · Roseburg, ORN9911QAeronautical Technical Service Inc · Collierville, TNN9911VInternational Air Services Inc Trustee · Carson City, NVN9911XDesolation Aviation LLC · Fort Worth, TXN9912AEvans Alfred M Jr · Kingston, OKN9912LCivil Air Patrol Inc · Maxwell Afb, ALN9912NRegistered aircraftN9912QKd Aviation LLC · Sheridan, WYN9913EHobot LLC · Springdale, ARN9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeN9913MVillapudua Ruben Ruiz · Phoenix, AZN9913VIsern Douglas J · Golden, CON99141Airgo Inc · Centralia, ILN9914ESimica Charles A · Marietta, GAN9914GKunas Matthew · Akron, OHN9914LFlex Air Holdings Inc · Manhattan, KSN9914MLabra Victor David · Mesa, AZN9914QVictor Aviators Inc · Kernersville, NCN9914VJennair LLC · Wilmington, DEN99157Hess Garrett J · Fullerton, CAN9915AAbel Elliot A · Terre Haute, INN9915BTaro Investment LLC · Doral, FLN9915HTj Aero LLC · Valencia, CAN9915MBoone John G · Goleta, CAN9915NKackley Floyd L · Grand Rapids, MNN9916Addison William S · Colorado Springs, CON9916ESchult Jessica Elaine · Boise, IDN9916HSky Blue Adventures LLC · Boulder, CO
Back to AD 87-20-03 R2