OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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.

N776KRRoman Carlos · Aguadilla, PRBuilt 2008 · S/N 4692071N776MFBering Capital LLC · Anchorage, AKBuilt 1981 · S/N 34-8133186N776NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881044N776NGMaus Air LLC · Dallas, TXBuilt 2021 · S/N 4636776N776PMHoudashell Investments LLC · Amarillo, TXS/N 3480N776TXAbh776tx LLC · Carlsbad, CABuilt 2021 · S/N 2754N7772ANorthern Computers Inc · Madawaska, MEBuilt 2008 · S/N 411035N7773HCirrus 7773h LLC · Wilmington, DEBuilt 2003 · S/N 0723N7774ZLaw Office Of Yossi Noudel · Encino, CABuilt 2005 · S/N 1345N7777FPlastech Corporation · Atlanta, GABuilt 1989 · S/N 4622016N7777GNittany Flyin LLC · Amarillo, TXBuilt 1991 · S/N 4622118N777ACAerozona 1 Inc · Phoenix, AZBuilt 2016 · S/N 4636687N777AJV-R Holdings LLC · Sauget, ILBuilt 2008 · S/N 3132N777AQBcms Investments LLC · Dexter, MOBuilt 1979 · S/N BB-583N777AWFair Air Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N BB-536N777CL777cl Aviation LLC · Sheridan, WYBuilt 2019 · S/N 4758N777CWKeidel Mark T · Redlands, CABuilt 1977 · S/N 28-7890233N777ESD&J Aviation LLC · Gotha, FLBuilt 1997 · S/N 2843088N777EZInternational Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916216N777GBFc Sr Capital LLC · Anaheim, CABuilt 2018 · S/N 4637N777GVPerry Robert A · Tucson, AZBuilt 2002 · S/N 0235N777GXVlbr Partners LLC · Tallahassee, FLS/N 1646N777JLRegistration Pending · Lighthouse Point, FLRegistration pendingBuilt 2021 · S/N 4636792N777KATake-Off LLC · Knoxville, TNBuilt 1978 · S/N LW-285N777MGSe Aviation LLC · Champlin, MNS/N 4697066N777NDFreed David · Santa Barbara, CABuilt 2002 · S/N 1258N777NFN777nf Aviation LLC · Fort Worth, TXS/N 3246206N777NLOrthoair LLC · Union City, TNBuilt 2007 · S/N 2885N777PGLee Christopher M · Enid, OKBuilt 2010 · S/N 4636486N777PSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0097N777RYMacair Aviation LLC · Xenia, OHBuilt 2003 · S/N 0777N777SBFamily Centered Medicine LLC · Lawrence, KSBuilt 2006 · S/N 41709N777SDBoomerang Air LLC · Cedar Park, TXBuilt 1980 · S/N 28-8190125N777SSCalderwood Aviation LLC · Shafter, CABuilt 1980 · S/N BB-661N777VVDeluxe 8 LLC · New Orleans, LABuilt 2014 · S/N 4068N777WXMullins William Scott · Senoia, GABuilt 2003 · S/N 0452N777WZM6 Aviation LLC · Acworth, GABuilt 2011 · S/N 4636491N777YHCombined Air Ventures LLC · Avon Park, FLS/N 40.451N777YPTim Edwards Co LLC · Wilmington, DEBuilt 2005 · S/N 1299N777YUEvenhaim Ronen · Canoga Park, CABuilt 1980 · S/N 32R-8029065N777ZV777 Aviation LLC · Bedford, MABuilt 2004 · S/N 40.364N777ZWSky Safety Inc · San Antonio, TXBuilt 2004 · S/N 40.366N77877Air Vector LLC · Bountiful, UTFirst renewal noticeBuilt 2010 · S/N 3713N7788TIn Motion Aviation Group LLC · North Hollywood, CABuilt 2000 · S/N 1088N7789TAquila Air LLC · Shacklefords, VABuilt 2008 · S/N 1989N778CWingnut Aviation Group LLC · Seymour, CTBuilt 2006 · S/N 3255046N778CAMas Aviation LLC · Laurel, MSBuilt 2011 · S/N 3760N778DAT And S Capital Holdings LLC · Tampa, FLBuilt 2022 · S/N 8707N778DSGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 40.678N778NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881045
Back to AD 2008-06-28 R1