OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2695PDodge Alan J · Miles City, MTBuilt 1955 · S/N 18-4384N2695TJean-Baptiste Joseph C Sr · Brockton, MABuilt 1971 · S/N 28-7225089N2695ZJark David L · Stratford, SDS/N 1015-78N26961Slater Thomas R · Franklin, TNBuilt 1979 · S/N AA5A0840N26962Velasquez Rick · Puyallup, WABuilt 1979 · S/N AA5A0842N26963N26963 LLC · Montville, NJBuilt 1979 · S/N AA5A0843N26964Maurer Sandra E · Columbia Station, OHBuilt 1979 · S/N AA5A0846N26969Registered aircraftBuilt 1979 · S/N AA5A0849N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218N2696GGrabeman Allan · Fishers, INBuilt 1967 · S/N 325N2696RBowen Diane M · Newbury, MABuilt 1969 · S/N 28R-35248N2696TRsp Aero LLC · Griffin, GABuilt 1971 · S/N 28-7205087N2696WButler Collin · Danvers, MABuilt 1966 · S/N 3325N2696ZAdriatic Holdings LLC · Cheyenne, WYBuilt 1978 · S/N 1230-78N26973Miller Ronald DBA · Hattiesburg, MSBuilt 1979 · S/N AA5A0852N26976Luke Jeffrey David · Teague, TXBuilt 1979 · S/N AA5A0855N26985Hahn Jeffrey S · Guttenberg, NJBuilt 1979 · S/N AA5A0861N26986Jones Steven A · Paola, KSBuilt 1979 · S/N AA5A0862N26988Kazakova Liudmila · Hereford, AZBuilt 1979 · S/N AA5A0864N2698PMajors Nathaniel Ray · Ball, LAS/N 18-4388N2698WLivesay Wallace · Friendswood, TXBuilt 1966 · S/N 1011N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318N26993Gugel Joseph C Jr · Gettysburg, PABuilt 1979 · S/N AA5A0866N26994G & G Aviation LLC · Stedman, NCBuilt 1979 · S/N AA5A0868N26997Niver Rex E · Jenks, OKBuilt 1979 · S/N AA5A0869N2699MJohnson George W · Seattle, WAS/N 12-1203N2699WKingman Connor Joseph · Lemoore, CAS/N 1012N269AReynolds Darryl G · Wills Point, TXBuilt 1965 · S/N 1050403N269ABSkyline Aviation Inc · San Angelo, TXBuilt 2023 · S/N S1982N269ACBurks Aviation Inc · Hattiesburg, MSBuilt 2002 · S/N 1386-2002N269AJSkyline Aviation Inc · San Angelo, TXBuilt 2025 · S/N S1983N269AMBekraoui Hicham · Pasadena, CABuilt 2004 · S/N 20-1036N269ATSnyder Arthur P · Trevorton, PABuilt 2005 · S/N 1001N269BTorres Ramon A · Mulberry, FLFirst renewal noticeBuilt 1958 · S/N 127N269BFLehmann Micheal · Lena, ILBuilt 2003 · S/N 21421N269BJN2893e LLC · Reno, NVS/N 17270380N269BMOlsen Jared · Phoenix, AZBuilt 2002 · S/N 60130N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269CNN9660f LLC · Grand Ledge, MIBuilt 2024 · S/N S1981N269CPCutler Adam Wilson · Kennebunk, MEBuilt 2000 · S/N 80269N269DACole Thomas Ed · White Settlement, TXFirst renewal noticeBuilt 1968 · S/N 269N269DBDesilva David I · Baton Rouge, LABuilt 1992 · S/N 20816N269DDAircraft Solutions Group LLC · Englewood, COBuilt 2005 · S/N 172S9981N269EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13509N269FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10885N269HVertical Development LLC · Birmingham, ALBuilt 1978 · S/N 780715N269HAN269ha LLC · Manassas, VAS/N S1406N269HHCaprock Technical Services Inc · Kempner, TXS/N 12-0041N269JFinney James R · Howe, TXBuilt 1992 · S/N 269N269JATeam Aero LLC · Shawnee, KSBuilt 2008 · S/N S1914
Back to AD 81-18-04 R2