AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N71KJAanstad William L · Ofallon, ILN71KKHeadrick Silas · Sparta, TNN71KSLazenby Gary M · Harpster, IDN71KTL 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, NJN71PKBob 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, CAN71WSMello Matthew D · Exeter, CAN71WYCape Island Aviation LLC · Millville, NJN71YYAgl Flight LLC · Callahan, FLN71ZZPlum 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, SD
Back to AD 81-18-04 R2