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.

N4595FSchroeder Herbert D · Plano, TXBuilt 1976 · S/N 28-7790049N4595JPetesch Andrew L · Meriden, KSBuilt 1968 · S/N 28R-30471N4598FLedkins Logan D · Mineola, TXBuilt 1976 · S/N 28-7790050N4598JPerricone David M · Webster, NYBuilt 1968 · S/N 28R-30475N4598XRs Aero LLC · Palm City, FLBuilt 1975 · S/N 28-7690048N4599JMidway Enterprises Inc · Wilmington, DES/N 28R-30477N459BBSanchez Frederick A · Lancaster, CABuilt 1968 · S/N 28R-30533N459BTAir Conrad LLC · Duncansville, PABuilt 2002 · S/N 1225N459CDUrsine Teleportation LLC · Redmond, WABuilt 2005 · S/N 1535N459FG6126 Mabrey LLC · Ruskin, FLBuilt 2003 · S/N 3257333N459MARani9650 LLC · Lathrop, CABuilt 1975 · S/N BB-36N459SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496492N459TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881859N459WEPoppe Stephen · Grants Pass, ORBuilt 1968 · S/N 28R-30530N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007N45CRose Up And Away LLC · Wilmington, DEBuilt 2019 · S/N 2475N45CCVcp Sr20 LLC · Vero Beach, FLBuilt 2018 · S/N 2437N45CDHillair Inc Trustee · Wilmington, DEBuilt 1979 · S/N 287916467N45CXRobin Aviation LLC · Plymouth, MIBuilt 2021 · S/N 5145N45DMRaolji Mahendra · Florida City, FLBuilt 2018 · S/N 4634N45EAEcho45 Aviation LLC · Walnut Creek, CABuilt 2025 · S/N 11097N45FWBleuggs Aviation LLC · Lewes, DEBuilt 1996 · S/N 3246045N45GLOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2006 · S/N 1870N45HHKittle Andrew · Wake Forest, NCS/N 32-46180N45JNSpotts Marcus P · Nora Springs, IABuilt 2003 · S/N 0489N45KSRentals Deltona 2 LLC · Orlando, FLBuilt 2025 · S/N 11080N45PESix Flying Monkeys LLC · Frisco, TXBuilt 1980 · S/N 32R-8013074N45PWEralet Inc · Middletown, DEBuilt 2019 · S/N 4841N45RAHurula Jeffrey J · Drummond, WIBuilt 1981 · S/N 28-8290041N45SDEast Hill Seneca LLC · Ithaca, NYBuilt 1981 · S/N 34-8233016N45VUVincennes University · Vincennes, INBuilt 2018 · S/N 2443N45WTMccarthy Brothers Aviation LLC · Albany, KYBuilt 2010 · S/N 3709N4601JHardin John M · Terrell, TXBuilt 1968 · S/N 28R-30479N4602JNew Garden Township · Landenberg, PAS/N 28R-30481N4603JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-30482N4604JTrouth Kevin J · Sulphur, LAS/N 28R-30483N4605JNichols James M · Duanesburg, NYS/N 28R-30485N4606JKantor Robert James · Rancho S Margarita, CABuilt 1968 · S/N 28R-30486N4607JHodgen Robert T III · Lexington, KYBuilt 1968 · S/N 28R-30487N460AAAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 2881528N460ABCrouse Aviation LLC · Napa, CABuilt 2010 · S/N 4697431N460LABlss Aviation Group LLC · Monrovia, CABuilt 2026 · S/N 11159N460NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881655N460SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 4496551N460SRBuchman Barry Joseph · Atlanta, GABuilt 2008 · S/N 3093N460SUBoelte Aviation LLC · Edmond, OKBuilt 2022 · S/N 8669N460TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881860N460UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020163N460XSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816581N4614JHendershot Kevin E · Owens Cross Roads, ALBuilt 1968 · S/N 28R-30494
Back to AD 2008-06-28 R1