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.

N186PSRricko LLC · Portland, ORS/N 4697228N186SB8810 Capital Holdings LLC · Jupiter, FLBuilt 2022 · S/N 8810N186SPClear2 Aviate LLC · Ionia, MIBuilt 1977 · S/N 28-7790514N186STInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 4692086N186WWWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2004 · S/N 4496186N187AJAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2016 · S/N 4356N187ARPiper Aircraft Inc · Vero Beach, FLS/N 28010087N187DSSfl Enterprises LLC · Speedwell, VABuilt 2005 · S/N 40.574N187FTTowater Ronnie A · Ocala, FLS/N 28-8216197N187JDMacarthur Dougald F · Littleton, NHBuilt 2004 · S/N 4697180N187MRJcs Air LLC · Auburn, ALS/N BB-873N187PHPutnam Mark A · Chester Springs, PABuilt 2011 · S/N 2081N187SDHelo-Max LLC · Dublin, GABuilt 1989 · S/N 2841065N187SPFarwick Brent T · Louisville, TNBuilt 1977 · S/N 287790372N187SRSpirit Property Development LLC · Addison, TXBuilt 2006 · S/N 1950N187TCRiesenberg Tyson Robert · Bountiful, UTBuilt 2001 · S/N 3257261N187TPR G R Holdings LLC · Spring Branch, TXBuilt 2006 · S/N 2843627N187TXXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496099N1880E L I Land Design LLC · Montgomery, TXBuilt 2001 · S/N 0110N1880APlaneco LLC · Lincoln, NEBuilt 1978 · S/N 441-0080N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N188CECruise Air LLC · Wilmington, DEBuilt 2005 · S/N 4697239N188CTPlane Fun Inc Tr Trustee · Snellville, GAS/N 2983N188DXPiper Aircraft Inc · Vero Beach, FLS/N 28010104N188GMckee Kent M Trustee · Varna, ILS/N 3102N188JRNwga Aero Farms LLC · Dalton, GABuilt 2015 · S/N 2298N188KCMalibu Management LLC · Ponte Vedra, FLBuilt 2013 · S/N 4636588N188LAAvf Flyers LLC · Richmond, VAS/N 4636185N188LGMyskinmedspa LLC · Rockledge, FLBuilt 1989 · S/N 4622043N188MAAviation Leasing LLC · Erie, COBuilt 2008 · S/N 3096N188PMCairn Vista Holdings LLC · Santa Rosa, CABuilt 2012 · S/N 4697501N188TErmg-1 Holdings LLC · Coral Springs, FLBuilt 2024 · S/N 10073N18916Valiair Lc Trustee · Casper, WYBuilt 2006 · S/N 2075N1896SSky Dds LLC · Las Vegas, NVBuilt 1998 · S/N 3449088N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189CSHelo-Max LLC · Dublin, GABuilt 2021 · S/N 28020039N189ECCollins Richard · Oceanside, NYS/N 28-8290061N189FGAerotech Coatings LLC · Arlington, WABuilt 2016 · S/N 4378N189JBSpin Off Aircraft LLC · West Palm Beach, FLBuilt 1979 · S/N 28-7990190N189MHSpirit Life Inc · Morrison, COBuilt 1998 · S/N 4636159N189MJBarnes Aviation LLC · Flowood, MSBuilt 2004 · S/N 3257340N189PGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 1896N189RPElferdink Steven · Naples, FLBuilt 2006 · S/N 3257410N189SPKilpatrick Blake E · Canyon Lake, TXS/N 28-8016137N189WMSanborn-Hill Aviation LLC · Arden, NCBuilt 2019 · S/N 2507N18AVAdvanced Aviation LLC · Merrick, NYBuilt 2018 · S/N 4729N18DNZba LLC · Hurricane, UTBuilt 2001 · S/N 0096N18GKJackson Air LLC · Duluth, MNBuilt 2013 · S/N 2225N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229
Back to AD 2008-06-28 R1