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.

N25309Workman Paul E · Urbana, OHBuilt 1940 · S/N 1031N2530NGibbs Robert I · Ravenswood, WVBuilt 1979 · S/N 38-79A0899N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604N2530WHeir Michael R · Clarksville, MDS/N 950N25315Ifr Inc · San Juan, PRS/N 1003N2531ATyler Jeffery Jack · Anchor Point, AKBuilt 1978 · S/N 38-78A0735N2531FFishwick Steve K · Hamilton, OHBuilt 1966 · S/N 22N2531MCurtis Kevin R · Flushing, MIBuilt 1946 · S/N 12-1022N2531RMaierhoffer Henry F Jr · Sylvania, GAS/N 28-5642N2531YPremier Aviation LLC · Sioux Falls, SDBuilt 1985 · S/N 28-8590083N25325Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280596N2532DSherlock William H · Greenbrae, CABuilt 1989 · S/N 868N2532MNolan John R · Colorado Springs, COS/N 897N2532PRiley Mitchell C · Seattle, WABuilt 1955 · S/N 22-2895N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207N25332Ewing John L Jr · Yuma, AZBuilt 1977 · S/N 15280600N2533MJohnson Cory R · Owatonna, MNBuilt 1946 · S/N 12-925N2533VHasselvander Brian K · Columbia, MSBuilt 1974 · S/N 177RG0605N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208N25340Resetich Michael J · Gravois Mills, MOBuilt 1980 · S/N 38-80A0111N2534AWilcoxon James · Scobey, MTBuilt 1952 · S/N 18-2152N2534BMckane Holdings LLC · West Point, MSBuilt 2003 · S/N 004N2534MBooher John R · Eagle River, AKBuilt 1946 · S/N 12-926N2534PPearson Vincent N · Broken Bow, NES/N 22-2897N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214N25351Russell Robert Q · Genoa City, WIBuilt 1977 · S/N 15280609N25357Jameson George T · Auburn, MABuilt 1977 · S/N 15280612N25359Kelly John M · Gastonia, NCBuilt 1977 · S/N 15280614N2535ESale Reported · Griffin, GASale reportedBuilt 1989 · S/N 876N2535FBryan Michael R · Brownfield, TXBuilt 1965 · S/N 7GCAA-33N2535UMyer Mark A · Sandusky, OHBuilt 1979 · S/N 28-8090054N2535VRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1974 · S/N 177RG0606N25362Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280616N2536AA & J Air Sales Inc · San Antonio, TXBuilt 1978 · S/N 38-78A0739N2536EEarle James K · Argonia, KSBuilt 1959 · S/N 22-6816N2536ZLemanski Thomas A · Port Townsend, WAS/N 1250-78N2537DBurdette William E · Corpus Christi, TXBuilt 1978 · S/N 38-79A0359N25386Fairview Farms Inc · Poteau, OKBuilt 1985 · S/N 28-8590088N2538ARegistration Pending · Sheridan, WYRegistration pendingBuilt 1978 · S/N 38-78A0740N2538GFerrell Herman H · Oak Grove, LABuilt 1967 · S/N 411N2538VDavidson Joel R · Granville, NYS/N 177RG0607N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215N2538ZSnell Marion Lea · Ackerly, TXBuilt 1977 · S/N 342-77N25393Oliver Blake H · Talbotton, GAS/N 15280631N25399Hudson Donald L · Camarillo, CABuilt 1977 · S/N 15280633N2539BRegistered aircraftBuilt 1978 · S/N 38-79A0116N2539GTpt Aviation LLC · Caseville, MIBuilt 1979 · S/N 38-79A0550N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806N253ATAirlines Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496057
Back to AD 81-18-04 R2