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.

N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844N246ACMateski James C · Salmon, IDBuilt 1946 · S/N 12-684N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N246AJJensen Alan · Rock Springs, WYBuilt 2013 · S/N 82207N246AKGordon Andrew J · Paulding, OHBuilt 1999 · S/N 778N246ARMaravillas Ng LLC · Cupertino, CABuilt 2023 · S/N 18283215N246AWSullivan Stanley D · South Jordan, UTS/N 72610N246AZRegistered aircraftBuilt 1983 · S/N 28-8311025N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485N246CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12340N246DAAdams Dennis M · Idaho Falls, IDBuilt 2021 · S/N 92131N246DTElswick Theodore · Fernley, NVS/N 71828N246EBeltz Roy C · Leesville, LABuilt 2026 · S/N 8960N246FC69px LLC · Suttons Bay, MIBuilt 2023 · S/N 246N246HNStamos Michael A · Buchanan Dam, TXBuilt 1986 · S/N 246N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003N246JDHilliard Bruce · Grantsville, UTS/N 74-31105N246JKTobin Thomas · Sparks, NVBuilt 2000 · S/N 99197N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535N246JSSullivan Jason W · North Pole, AKS/N 60201N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91N246LDHoppe Nicholas J · Big Lake, AKBuilt 1952 · S/N 18-1945N246MCChoules Michael K · Caldwell, IDBuilt 2010 · S/N 20247N246MEWyoming Seaplanes LLC · Alpine, WYBuilt 2000 · S/N T20608194N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N246NSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608246N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PKGeneva1 Aviation LLC · Mars, PABuilt 1995 · S/N 20008N246PMBesprozvanny Randy-Alexander R · San Marcos, CABuilt 1977 · S/N AA5B-0566N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005N246RKFreeborn Mark Trustee · Phoenix, ORS/N 22861N246RLSwiss Eagles Inc · Las Vegas, NVBuilt 1984 · S/N L-0026N246SBBeatty Steve K · Glendale, AZBuilt 2004 · S/N 0130N246SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13442N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023N246SRFriendship Church · Frisco, TXBuilt 2006 · S/N 042SRN246SVN246sv Corp Trustee · Wilmington, DEBuilt 2001 · S/N 25068CN246TFMorgan Daniel D · Topeka, KSS/N R18201677N246TMTango Mike Aviation LLC · Seneca Falls, NYS/N 3238N246TTTerry Timothy D · Gainesville, TXS/N 70518N246UAdelaar Holdings LLC · Missoula, MTBuilt 2020 · S/N 3360N246VABrascher Harry M · Spotsylvania, VABuilt 2003 · S/N 81121N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427N247Bonewitz John A · Grapevine, TXBuilt 1999 · S/N 23846N24704Blumer Charles · Fullerton, CAS/N 38-78A0785N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332N2470BAlpha International Aircraft Inc · Lewes, DEBuilt 2005 · S/N 172S10069
Back to AD 81-18-04 R2