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.
N5424PHerreid William L Jr · Prairie Du Chien, WIN5424QBeltzville Aero LLC · Lehighton, PAN5424SNeely Benson W · Florence, MSN5424VSorbi Aviation Inc · El Cajon, CAN5424ZGavlik Joseph A II · Lincoln, RIN54257Meridian Airport Authority · Meridian, MSN5425LHamilton Paul DBA · Fresno, TXN5425MWong Alex · Hillsborough, CAN5425SBunn James W · New Port Richey, FLN5425WIrmen Walter Michael Jr · Arlington Heights, ILN5425YWilson Leif L · Tok, AKN5426Vieira Mark · Turlock, CAN54266Low Country Skyways LLC · Wilmington, DEN5426FPressley Aviation LLC · New London, NCN5426JMedia Stew LLC · Carson City, NVN5426MWorthington Aras · Anchorage, AKN5426PTromble Tim L · Story, WYN5426QLen Emery Photography LLC · Springfield, VTN54273Swanson Gary A · Fort Bragg, CAN5427FRebel Aviation Inc · Liberty, MON5427ZRegistration Pending · Dothan, ALRegistration pendingN54283Sale Reported · Lewistown, MTSale reportedN54285Monahan Richard J Jr · Budd Lake, NJN54288Chandler Air Service Inc · Chandler, AZN5428FSchold Maury W · Stafford Springs, CTN5428LMacair Aviation LLC · Xenia, OHN5428WBon Investment Holdings LLC · Zephyrhills, FLN54290Laguna Verde Leasing Inc · Wilmington, DEN54291Flight School Of Gwinnett Inc · Lawrenceville, GAN54296Honcho Aircraft LLC · Crosby, TXN5429FQuick Kenneth C Jr · Burke, VAN5429LGardner T Larry · Dickson, TNN5429PSky West Aviation Inc Trustee · Albuquerque, NMN5429WLafontaine Generator Exchange Inc · La Fontaine, INN542APa28 Aircraft LLC · Wilmington, DEN542CWCentral Washington University · Ellensburg, WAN542EClegg Edward T · Standish, MEN542ECWang Warner Weihsu · Vienna, WVN542EREmbry Riddle Aeronautical University Inc · Prescott, AZN542EZLesher Caleb J · Cottonwood, CAN542FCooper Nina · Lake Elmo, MNN542FLHaffey George F · Fernandina Beach, FLN542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedN542HGraham Jack D · Hamilton, TXN542HFPars Avn Corp · Wilmington, DEN542JJAlf Ix LLC · Chicago, ILN542JPGrauer Keaton · Marysville, KSN542JVBeaubien Matthew L · Sacramento, CAN542KAtp Aircraft 3 LLC · Wilmington, DEN542KSKent State University · Stow, OH
Back to AD 81-18-04 R2