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.

N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeBuilt 1968 · S/N 28-4993N6549ZRivers Larry R · Talkeetna, AKBuilt 1962 · S/N 18-7879N654ACFlying Sparks LLC · Tomball, TXBuilt 1998 · S/N 1367-98N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033N654BCCobb Charles J · Fallbrook, CABuilt 1969 · S/N 28-5335N654CRLinde Rodney C · Weatherford, TXBuilt 2003 · S/N 80734N654CSCharlies Angel LLC · New Castle, DEBuilt 2002 · S/N 172S9166N654EZN654ez LLC · Oyster Bay, NYBuilt 2006 · S/N 1741N654FKimmel John · Milwaukie, ORBuilt 1991 · S/N 7-0065N654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1971 · S/N 28-7125569N654FTFlorida Institute Of Technology Inc · Melbourne, FLS/N 28020172N654JFFreele James E · Rio Rancho, NMBuilt 1999 · S/N 4116N654JWWilson Jared D · Midway, UTBuilt 2019 · S/N 40470N654MRlw Wholesale LLC · Myrtle Beach, SCBuilt 2004 · S/N 40.412N654MLSmoking Hole Aviation LLC · Milford, NHS/N 2750N654NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11470N654NSElks Stephen A · Mountain City, TNBuilt 1974 · S/N 133N654PAPurdue Aviation LLC · West Lafayette, INBuilt 2018 · S/N 172S12141N654PJPajak Paul J · Groveland, FLBuilt 2006 · S/N 72216N654PTAnerv6a LLC · Minneapolis, MNBuilt 2012 · S/N 60557N654PVHouston Traville S · Granbury, TXBuilt 2011 · S/N 41035N654RTKonrad Melvin J · Cumming, IABuilt 1999 · S/N 24776N654RVVan Hoff Eric J · Gunter, TXBuilt 2003 · S/N 1898N654SHHutcherson David R · Gretna, VABuilt 2003 · S/N 3505N654SPJm Air Holdings LLC · Stevensburg, VABuilt 1998 · S/N 172S8060N654WGlaeser Chris R · Plymouth, MNBuilt 2006 · S/N 71993N654WMMillar Rick A · Anchorage, AKBuilt 2012 · S/N 001N654YRVet Air LLC · San Juan, PRBuilt 1964 · S/N 28-1867N65501Right Rudder Arizona LLC · Litchfield Park, AZBuilt 2004 · S/N 172S9721N65503Bentz Andreas · Falls Church, VABuilt 1983 · S/N M2378N65506Skelton James P Jr · Lithia Springs, GABuilt 1978 · S/N 15281593N65507Cora & Associates LLC · Norcross, GABuilt 2004 · S/N 18281454N6550JJans Stanley E · Dakota City, NEBuilt 1968 · S/N 28-4994N6550PLux Kevin C · Vancouver, WABuilt 1960 · S/N 24-1672N6550UGeorge Ladelle L · Ashley, NDBuilt 1963 · S/N 2333N65512Wiebe Van Michael · Filer, IDBuilt 2004 · S/N 18281457N65514Vogt Gregory A · Broken Arrow, OKBuilt 2004 · S/N 18281458N65516J-Airco LLC · Nashville, TNBuilt 1982 · S/N 17275769N65518Tk Equipment LLC · Brownsburg, INBuilt 1982 · S/N 17275771N6551LParker Kerry · Hobbs, NMBuilt 1974 · S/N AA5-0651N6551PWsv Aero Inc · Wilmington, DEBuilt 1959 · S/N 24-1673N6551UAuker Donald · Lebanon, PABuilt 1962 · S/N 2334N6551WThull Stanley B · Freeport, MNBuilt 1965 · S/N 28-20631N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775N6552BHollenberg Randall W · Houston, TXBuilt 1979 · S/N 15283948N6552FAir Planes LLC · Soddy Daisy, TNBuilt 1979 · S/N 17273239N6552JCherokee Flyers Inc · Phoenixville, PABuilt 1968 · S/N 28-4997N6552PSyc Holdings LLC · Missoula, MTBuilt 1960 · S/N 24-1674N6552UGoldstein Meyer · Underwood, WABuilt 1962 · S/N 2335
Back to AD 81-18-04 R2