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.
N761UAFirst Wings LLC · Sayre, PAN761WWilliams Richard G J · Labelle, FLN761YEUnique Educational Experiences Inc · Signal Hill, CAN7620FRed 5 LLC · Kalispell, MTFirst renewal noticeN7620GDc Aero LLC · Ramona, CAN7620HMckinney Leonard F · Anchorage, AKN7620KBarnes Thomas M · Pittsboro, NCN7620PSopwith James T · Sacramento, CAN7621EGrey Matter Inc · Valley Springs, CAN7621FMeier Scott F · Jupiter, FLN7621GCrewdawg Aviation LLC · Concord, NCN7621PMckusick Eileen D · Winooski, VTN7621SSmith Michael D · King George, VAN7621WAlexander Steven W · Kansas City, MON7622GBell Sky Pilots Inc · Reedley, CAN7622HEngler Eric M · Cass City, MIN7622JSkylink Aviation Inc · Florissant, MON7622KCooper Kristopher A · Hamersville, OHN7622LHowe Jamie W · Boynton Beach, FLN7622PGriffin Robert L Jr · Washington, NCN7622WBarnett Donald R · Atoka, TNN7623DBaker Donald A · Macedon, NYN7623GPlane Sane Aero LLC · Cary, NCN7623HCowan Drew Paul · Anchorage, AKN7623JWhite Jeffrey M · Carlsbad, CAN7623RAdamiak Jeffrey · Mount Laurel, NJN7623SKrejchik Daniel J · Portage, WIN7623VGove Richard · Riverside, CAFirst renewal noticeN7623WMidwest Heavy Construction LLC · Pleasant Hill, MON7624GAeroflight Flying Club Inc · Jackson, TNN7624JBriggano LLC · Mount Pleasant, SCN7624SHovey Gregg Beecher · San Diego, CAN7624WHartley Douglas R · Florence, ALN7625FHarbaugh Steven J · Riverside, CAN7625HCook Susan R · Carl Junction, MON7625JHuebscher Attila · Flemington, NJN7625MMccowan Kenneth L · Kansas City, KSN7625PVfr2imc LLC · Elko, NVN7625SN4457s LLC · Southport, NCN7625WWings Up LLC · Manteno, ILN7626FJamestown Jet Center Inc · Jamestown, NDN7626KTopp Audrey · Reno, NVN7626LLester Androcles J · Ester, AKN7626PZervos Fredric W · Orland Park, ILN7626RBasinger Weston P · Alexandria, VAN7626WStiles Kenneth R · Ozawkie, KSN7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeN7627DVanhouse Daniel W · Topeka, KSN7627FLo Co Holdings LLC · Loudon, TNN7627KEngwis Douglas R · Rhodes, MI
Back to AD 81-18-04 R2