Registered aircraft · 18,495

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

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') ORDER BY n_number

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N770MVChapman Jeffrey C · Brownsburg, INBuilt 1974 · S/N 310R0067 N770PMachin Susan M Trustee · Newport Coast, CABuilt 1975 · S/N E-749 N770THoyer Kyle E · Manassas, VABuilt 1972 · S/N D-9396 N77100Nodine John · Leicester, NCBuilt 1980 · S/N TE-1184 N7710RBeechcraft Heritage Museum · Tullahoma, TNBuilt 1969 · S/N E-103 N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170 N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072 N7711LClick Justin T · Hobart, INBuilt 1969 · S/N 185-1521 N7713RWaggoner Mark B · Fort Worth, TXBuilt 1968 · S/N D-8871 N7714RPowell Kenneth Wayne · Ann Arbor, MIBuilt 1969 · S/N D-8956 N7715BHinton Steven J · Chino, CABuilt 1968 · S/N TE-540 N7719QTurel Stanley · Bend, ORBuilt 1973 · S/N 3400194 N771BB406 Mountain Air LLC · Bigfork, MTS/N EA619 N771CCCastanza Gregory M · Berlin, CTBuilt 2011 · S/N TH-2304 N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046 N771KSWieczorek Michael A · Athens, GABuilt 2005 · S/N 1717 N771MAgs Leasing Services LLC · Shoreview, MNBuilt 1971 · S/N E-293 N771MPFl072 Aviation LLC · Brentwood, TNBuilt 1974 · S/N 340-0368 N771RBBogin Robert M · Los Angeles, CABuilt 1964 · S/N D-7737 N771SL3vr Aviation LLC · Annapolis, MDBuilt 2005 · S/N 1405 N771TFudge Justin · Karnes City, TXBuilt 1972 · S/N D-9415 N771WGSell Shannon · Hoschton, GABuilt 2008 · S/N E-3835 N771XRanney Dorothy Gayle · Cordova, AKBuilt 1967 · S/N 185-1336 N77206Venture Alaska LLC · Homer, AKBuilt 1977 · S/N U20603771 N7723BBallinger Barry · Lubbock, TXBuilt 2008 · S/N E-3839 N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357 N7725RLynn Cain LLC · Augusta, ARBuilt 1968 · S/N TE-644 N772CManitoba Pacific LLC · Laguna Niguel, CABuilt 2002 · S/N 0401 N772CCWagner William · Oro Valley, AZBuilt 2005 · S/N 1539 N772CDHarllee Cattle Company LLC · Bradenton, FLBuilt 2005 · S/N 1403 N772DBAtb Aviation LLC · Wilmington, DEBuilt 2000 · S/N E-3314 N772MCayle Jonathan · Rochester, MIBuilt 1979 · S/N EA-14 N772MDMary Rabbit LLC · Saratoga, CABuilt 1997 · S/N EA-605 N772PCThompson John Christopher · Dallas, TXBuilt 2005 · S/N 29-0402 N772RMaverick Bills LLC · Wilmington, DEBuilt 1980 · S/N CE-912 N772RFSpencer John S · Indian, AKBuilt 1967 · S/N U206-0816 N772TTBrightwater Enterprises LLC · Lakeway, TXBuilt 2004 · S/N 42058 N7731RWilliams Metal And Machinery LLC · Irvington, ALBuilt 1968 · S/N TE-645 N7732RAluzion LLC · Madison, ALBuilt 1968 · S/N CJ-7 N7733ADvb Enterprises Inc · Colcord, OKBuilt 1988 · S/N CE-1261 N7734MHeinrich Bruce · East Burke, VTBuilt 2005 · S/N 29-0397 N77350Bottom Line Technologies Inc · Columbia, MDBuilt 2003 · S/N 42013 N7735RJavelin Banana LLC · Erda, UTBuilt 1968 · S/N CJ-8 N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420 N7737RPassmore Jay A · Birchwood, TNBuilt 1968 · S/N D-8876 N773CDMississippi Pepin Flyers LLC · Hager City, WIBuilt 2005 · S/N 1362 N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202 N773MSWild Blue Yonder LLC · Lees Summit, MOBuilt 1973 · S/N CE-472 N773PAir Data Solutions LLC · Natchitoches, LABuilt 1964 · S/N U206-0309 N7740RRegistered aircraftBuilt 1968 · S/N D-8877

Back to AD 86-13-04 R3