OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N12ACCarroll Alan R · Mc Farland, WIBuilt 2005 · S/N 80177N12ADAltizer John N · The Woodlands, TXBuilt 1994 · S/N JWA-2N12AKBurk Ross T · Casper, WYS/N 5695N12ALFuller Deidra K · Great Falls, MTBuilt 1981 · S/N DAV-1N12BEElliott Russell R · Wasilla, AKS/N 7082CN12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570N12BNNitz Bernard F Jr · Illinois City, ILBuilt 1992 · S/N 2033N12BVRoberts William O · Lexington, VAS/N 0241N12CGGreen Carlton · Carmel Valley, CABuilt 1996 · S/N 1320N12CPGeddes Paul M · Saint Paul, MNBuilt 1970 · S/N 1N12DDSpencer William D · Martinsville, VAS/N 248N12DJConklin Matthew J · Cornwall, NYS/N 12168N12DPKish Gary A · Montrose, MIBuilt 1975 · S/N 1212DN12DSBuckbee Robert E · College Station, TXBuilt 1984 · S/N 27N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038N12EHSteeneck Robert T · Washougal, WABuilt 1970 · S/N 48N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439N12FPElliott James R · Denton, TXBuilt 1974 · S/N 238N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635N12GCNorman Ashton J · Zanesville, OHBuilt 2000 · S/N 2264N12GKSpacewalker 2 LLC · Ocala, FLS/N 8197SWN12GLHayden Debra J · Utica, KYBuilt 1995 · S/N JR-2N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112N12GRJones Richard B · Georgetown, TXBuilt 2001 · S/N 2152N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124N12HCBirdwin LLC · Buras, LABuilt 1978 · S/N 909N12HDMorotti John · Polson, MTBuilt 2022 · S/N 3401N12HEOlafsen George F · Greeneville, TNBuilt 2007 · S/N 91367N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131N12HGNaylor John H · Conway, ARS/N 1N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664N12HTRanieri Paul A · Palatine, ILBuilt 2012 · S/N 5044N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345N12HYRegistration Pending · Nephi, UTRegistration pendingBuilt 1999 · S/N 1448N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12JVRaun Ian O · Sharpsburg, MDBuilt 1979 · S/N 88N12JXAc Holdings II Inc · Lewes, DEBuilt 1981 · S/N 025N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80N12LGLapiair LLC · Vergennes, VTBuilt 1998 · S/N 20418N12LMHaney Andrew J · Mt Morris, PAS/N 1001N12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12LTBaker William A · Lincolnton, NCBuilt 1972 · S/N 406N12LZConlon Joseph F · Gainesville, FLBuilt 2011 · S/N LZ001
Back to AD 81-18-04 R2