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.

N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425N7125PHernandez Jimmy Lee · Lamesa, TXBuilt 1961 · S/N 24-2286N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125UTakacs Robert S · Oxford, CTBuilt 1964 · S/N 364N7125VSutphen James A · Henderson, TXBuilt 1974 · S/N 22-0054N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N71266Kuhtenia David G · Galena, OHBuilt 2016 · S/N 60355N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126GHenry Rolla G Jr · Saint Charles, MOBuilt 1966 · S/N 30-1001N7126KWaller David · Carthage, MOBuilt 1958 · S/N 18-344N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7127RGreen William A · Memphis, TNS/N 28-21828N7127YSpencer Avionics Inc · Spencer, IABuilt 1963 · S/N 30-148N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428N7128PRegistered aircraftBuilt 1961 · S/N 24-2291N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128URegistration Pending · Billings, MTRegistration pending, canceledBuilt 1992 · S/N 889N7128VLinville Aero LLC · Chapel Hill, NCBuilt 1974 · S/N 22-0057N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7128YAir Mods And Repair Corp · Robbinsville, NJBuilt 1963 · S/N 30-149N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129PBachand Cade C · Dickinson, NDBuilt 1960 · S/N 24-2292N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N7129YButner Gary W · Yuba City, CABuilt 1963 · S/N 30-151N7129ZBlue Ridge Soaring Society Inc · New Castle, VABuilt 1964 · S/N 25-2947N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712DMFox Dennis C · Oklahoma City, OKBuilt 2012 · S/N 72775N712DTBrown Charles A · Boise, IDS/N 575N712EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12882N712GWArmstrong Michael L · Bend, ORFirst renewal noticeBuilt 2010 · S/N 107MN712JGBirdsong Brad · Lubbock, TXS/N 872-320-669-SFBN712JTSkylens LLC · Hammond, LABuilt 1979 · S/N 27-7954057N712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712LDBurns William J · Onalaska, WIBuilt 1982 · S/N 32-8206034N712LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11659N712MDMosley Daniel J · Jackson, MSBuilt 2015 · S/N 01N712MSNational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282179N712NVEpic Aviation Enterprises LLC · Austin, TXBuilt 2005 · S/N 172S9960N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712RFix Wing LLC · Fort Lauderdale, FLBuilt 1967 · S/N 18-8556N712RFFleming Ray J · Duson, LABuilt 2004 · S/N 70070N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640N712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYBuilt 1979 · S/N 27-7954083N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712
Back to AD 81-18-04 R2