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.
N71KTL L C LLC · Rapid City, SDN71LZGriffin Ralph J Jr · Thibodaux, LAN71MSTaf Aerial Services LLC · Beeville, TXN71NSSpeedy Nigel A · Cinnaminson, NJN71PRegistration Pending · Okeechobee, FLRegistration pendingN71PAGregory Edward P · Bernardsville, NJN71PBProgression Aviation LLC · Alpharetta, GAN71PKBob Hoover Academy · Salinas, CAN71PMAnderson Aviation LLC · Bulverde, TXN71PVCeleste LLC · Playa Del Rey, CAN71REEigsti Rodney E Trustee · Friend, NEN71RKOtt Randal K · League City, TXN71RLPatriot Capital Ventures LLC · Mokena, ILN71RZSmith John J · Middlefield, CTN71SATake Off LLC · Boise, IDN71SDRalph B Beatty LLC · Murrysville, PAN71SGRocket Sauce Engineering LLC · Columbia, MON71SHReese Jose A · Yuma, AZN71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN71TKKallio Thomas A · Carmel, INN71UPSisson Edward E · Northome, MNN71WFRobins David M · Tehachapi, CAN71WLWild Bill'S Aviation Inc · Tustin, CAN71WZArlington Aviation Inc Trustee · Wilmington, DEN71ZZPlum South Aircraft LLC · Abbeville, SCN7200GWe Fly High LLC · Helena, MTN7200JBell Dylan Will Nash · W Columbia, TXN7200LWorley Matthew · Cordova, TNN7200PThompson Grover A · Locust, NCN7200QFisher Eric C · San Francisco, CAN7200WAgri Air LLC · Fairfax, MON7200YBroussard Don W Jr · Wynne, ARN7201DEnyeart Warren L · Eagle River, AKN7201FPowell Jonathan C · Philadelphia, PAN7201HMcclure Richard A · Edna, TXN7201JTrebor Aviation LLC · Prescott Valley, AZN7201POrillac Natalie · Doral, FLN7201VCompass Rose Aviation LLC · Fort Myers, FLN7201WTaylor Robert · Greensboro, NCN7201XMathews Daniel R · Vallejo, CAN7202GUrmston Benjamin R · Sherborn, MAN7202JAir Indiana LLC · Noblesville, INN7202KCollins Michael P · Cordova, AKN72035Christiano Brett T · Pasco, WAN7203FLaird Grant M · Puryear, TNN7203GVenard Inc · Murdo, SDN7203JRegistration Pending · Tifton, GARegistration pendingN7203PGorge Fast Aviation LLC · Hood River, ORN7203ZConrad Coy S · Tobaccoville, NCN7204CHousley Communications Inc · San Angelo, TX
Back to AD 87-10-06 R1