OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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:87-18-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1')
  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.

N18457Colwell Arthur R · Magnolia, TXBuilt 1977 · S/N E-1133N18459Iglesia De Cristo · Porter Ranch, CABuilt 1977 · S/N E-1134N18462Sayers James B · Edison, OHBuilt 1977 · S/N E-1140N18463Bickett James C · Central City, KYS/N E-1137N18469Bonanza 469 LLC · Visalia, CABuilt 1977 · S/N E-1141N1846WChristenson R Darren DBA · Vernal, UTBuilt 1977 · S/N E-1138N18470Entwistle Charles W · Leicester, MABuilt 1977 · S/N D-10065N18474Sacandaga Air Inc · Fort Plain, NYS/N E-1309N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N18483F33a Holdings LLC · Woodbridge, VABuilt 1977 · S/N CE-735N1848XTeo Steel Inc · Ramer, TNBuilt 1981 · S/N E-1919N18496Willy P Air LLC · Fort Myers, FLBuilt 1977 · S/N E-1153N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362N1849LSpillman George R Jr · Argyle, TXBuilt 1976 · S/N E-848N1849PDaedalus LLC · Bozeman, MTBuilt 1982 · S/N CE-974N1849SOnedown LLC · Kalispell, MTBuilt 1981 · S/N CE-973N1849WCarrow LLC · Meredith, NHBuilt 1973 · S/N E-428N184AJFour Alpha Juliet LLC · Minster, OHBuilt 2004 · S/N E-3578N184DMRegistered aircraftBuilt 1998 · S/N E-3199N184EHTen Hi Flyers Inc · Denver, COBuilt 1989 · S/N CE-1355N184MBBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1976 · S/N TE-1075N1850FMarcus Air LLC · Plano, TXBuilt 1981 · S/N TE-1195N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N185HP185hp LLC · Sioux Falls, SDBuilt 1982 · S/N E-1996N185THsr Creative LLC · Indian Trail, NCS/N D-9672N1860AAry Co Ac & Heat LLC · Decatur, TXBuilt 1981 · S/N E-1933N1860WWhittaker Gary · Southport, NCBuilt 1973 · S/N D-9500N1861FKent Group Inc · Hazelhurst, WIBuilt 1981 · S/N E-1940N1861MLightspeed Enterprises LLC · Virginia Beach, VABuilt 1981 · S/N E-1936N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436N186RLN186rl LLC · Fortson, GABuilt 1993 · S/N CE-1748N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239
Back to AD 87-18-06 R1