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.

N675DDRice Allen J · Steinhatchee, FLFirst renewal noticeS/N 7647675N675EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12744N675GMMeuer Gary · Tullahoma, TNBuilt 2010 · S/N 007N675JBRegistered aircraftBuilt 2004 · S/N 22950N675JLLebechuck Kelly S · Murfreesboro, TNBuilt 1985 · S/N 1308N675LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881685N675MMDeane Steve P · Arlington, TXBuilt 2007 · S/N 008N675MPN9sa Corp Trustee · Wilmington, DEBuilt 1972 · S/N 32-7200037N675QFisher Global LLC · Conway, ARBuilt 1959 · S/N TD-246N675RFGoodson Danny R · Bristol, VABuilt 2021 · S/N 21845N675WMStoecklein Christine · Stanwood, WABuilt 2015 · S/N 1164-2015N67601Aero Maintenance Inc · Vancouver, WABuilt 1978 · S/N 15281939N6760BAnderson Michael N · Anchorage, AKBuilt 1954 · S/N 18-5035N6760WBitter Loren Mark · Maricopa, AZBuilt 1965 · S/N 28-20885N67611Kumor Ronald G · Casper, WYBuilt 1978 · S/N 15281945N67614Wampus Cats Inc · Davenport, IABuilt 1978 · S/N 15281948N67618Hale Douglas W · Perryton, TXBuilt 1978 · S/N 15281950N6761UJaeger Howard E · Claremore, OKBuilt 1963 · S/N 2483N6761WGirdley James Kevin · Taylorsville, KYBuilt 1965 · S/N 28-20886N67624Hardman Lorin D · Wasilla, AKBuilt 1945 · S/N 13937N6762BCarver Clarence K Trustee · Lutz, FLBuilt 1956 · S/N 18-5037N6762NTaylor Norman A · Fayette, ALBuilt 1968 · S/N 680076N6762WFox John M · Warrenville, ILBuilt 2000 · S/N 60224N67638Blue Feathers Corp · Newark, DEBuilt 1978 · S/N 15281954N6763JMiddlestetter Matthew G · Green Cove Springs, FLBuilt 1968 · S/N 28-24487N6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationBuilt 1968 · S/N 680077N6763PHeublein Eric C · Molalla, ORBuilt 1960 · S/N 24-1893N67648Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281960N6764BMccollum Glen R Jr · Nikiski, AKBuilt 1956 · S/N 18-5039N6764JZalik Michael A · San Francisco, CABuilt 1968 · S/N 28-24488N6764NBiermann William W · Hollister, CABuilt 1968 · S/N 690001N67651Salomonsson Mats · Fremont, CABuilt 1978 · S/N 15281963N67652Final Design Group LLC · Hurricane, UTBuilt 1978 · S/N 15281964N67657Jade Air LLC · San Pedro, CABuilt 1978 · S/N 15281965N6765NBogdan Joseph H · Soper, OKBuilt 1968 · S/N 680088N6765PJamison Ronnie L · Phoenix, AZBuilt 1960 · S/N 24-1895N6765WKakoczki Robert J · White Cloud, MIBuilt 1965 · S/N 28-20891N6766BRutland Norman L Jr · Birmingham, ALBuilt 1956 · S/N 18-5041N6766NFoley Erik J · Henderson, NVS/N 680079N6766PStephens Christopher R · Upper Marlboro, MDBuilt 1960 · S/N 24-1896N6767BHolseberg Aviation LLC · Ridgeville, SCBuilt 1956 · S/N 18-5042N6767CSilverstein Devyn · Austin, TXBuilt 1967 · S/N 670130N6767JLarson Wayne K · Amboy, CABuilt 1968 · S/N 28-24491N6767NEichhorn Tyler L · Paonia, COBuilt 1968 · S/N 680089N6767VParmenter Micah J · Aurora, COBuilt 1970 · S/N 700059N6768BKimmel Frank Stewart III · Greenwood, MSBuilt 1957 · S/N 18-5046N6768FFallis Robert P · Keller, TXBuilt 1972 · S/N AA5-0182N6768JSuncoast Flight Training LLC · Sarasota, FLBuilt 1968 · S/N 28-24492N6768NPorthouse Chris · Bellingham, MABuilt 1968 · S/N 680080N6768PKeenan John E · Saratoga, CABuilt 1960 · S/N 24-1899
Back to AD 81-18-04 R2