OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N879SRAlpha Foxtrot Aviation LLC · Ira, MIBuilt 2007 · S/N 2850N879TYKimmel Aviation LLC · Madison, MSBuilt 1978 · S/N BB-498N87ADCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11650N87BLAtlas Aviation Tampa Inc · Tampa, FLBuilt 2010 · S/N 3695N87CCWalton Marketing Inc · Fort Worth, TXBuilt 1981 · S/N 34-8133148N87CHTld LLC · Pasco, WABuilt 1972 · S/N LW-20N87DSCharlie Golf Aviation LLC · Hoover, ALS/N 1496N87HKCirrusly Indefensible LLC · Lincoln, NEBuilt 2021 · S/N 5023N87LEAircraft Partner Holdings Inc Trustee · BerlinBuilt 2002 · S/N 1190N87LPSoutheastern Transportation LLC · Pelham, ALBuilt 2002 · S/N 0279N87LSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 1830N87LTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1996 · S/N 3447013N87MCNorthern Blue Skies Inc · Shawano, WIBuilt 1980 · S/N 28-8090104N87PBH Kyle Sheets Md Pa · Ovalo, TXBuilt 2022 · S/N 4636804N87RFCider Mill Aviation LLC · Cape Elizabeth, MEBuilt 2022 · S/N 8621N87TCRix Industries · Benicia, CABuilt 2018 · S/N 4697648N87UPAir Transport Service LLC · Wilmington, DEBuilt 1999 · S/N 34-49144N87VBHus Winging It LLC · Santa Ana, CABuilt 2019 · S/N 2518N87WAltitude Aviation LLC · Lenoir, NCBuilt 1999 · S/N 2843296N87WSKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1977 · S/N 441-0009N87XCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 441-0133N880BTw880b Leasing LLC · Farmington, UTBuilt 2021 · S/N 4636788N880CDAl Batross Air LLC · Guntersville, ALS/N 0300N880DS4r Aero LLC · Bozeman, MTBuilt 2007 · S/N 40.887N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N880GMKnoxcirrus LLC · Oak Ridge, TNBuilt 2023 · S/N 9606N880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949N880SCKc Hawgs Inc · Wilmington, DEBuilt 1979 · S/N 32R-8029015N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268N8817MUniversal Aircraft Holdings LLC · Waterford, MIBuilt 2006 · S/N 2064N8818MCapitol Flyers LLC · Jefferson City, MOBuilt 2004 · S/N 0901N881DBJetprop Holdings LLC · Santa Fe, NMBuilt 1989 · S/N 46-22067N881DTCleary Brothers LLC · Tompkinsville, KYBuilt 1997 · S/N 3257007N881FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496235N881JVVoss James S · Boulder, COBuilt 2004 · S/N 1032N881KBAero Quest LLC · Olive Branch, MSBuilt 2023 · S/N 28020115N881PFInternational Air Services Inc Trustee · Carson City, NVS/N 2155N881PUTrustees Of Purdue University · West Lafayette, INBuilt 2025 · S/N 2881965N881RJAnnalith LLC · Englewood, FLFirst renewal noticeBuilt 2005 · S/N 3232049N881RLInternational Services Management LLC · Heath, TXBuilt 2007 · S/N 41738N881SRCjc Design Inc · Yorba Linda, CABuilt 2007 · S/N 2722N881TCBrait Aviation LLC · Edina, MNBuilt 2005 · S/N 1649N881UJBurke Farm Management Service Inc · Waynesboro, GABuilt 2006 · S/N 40.649N881WGots To Go LLC · Wilmington, DEBuilt 2005 · S/N 40.550N881WD306kc LLC · Hockley, TXBuilt 2004 · S/N 1215N881XPKusenberger Don L · Little Rock, ARS/N 2077N8824CRodriguez Carlos S · Poughkeepsie, NYBuilt 1976 · S/N 28-7690167N882ABWest Wings Aviation LLC · Lancaster, CABuilt 2009 · S/N 2022N882ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496317N882CDRegistered aircraftBuilt 2002 · S/N 0295
Back to AD 2008-06-28 R1