Skip to content

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

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

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.

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

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.

N750RTBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2021 · S/N 4496529 N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215 N750UOhio University · Albany, OHBuilt 2005 · S/N 2842226 N7510JArmstrong Craig V · Casstown, OHBuilt 1968 · S/N 28R-30876 N75114Henrichs Debra L · Galloway, OHBuilt 1976 · S/N 28-7690297 N75126Roth Darin · Max, NDBuilt 1976 · S/N 28-7690299 N7512JInfinity Aviation Group LLC · Nashua, NHS/N 28R-30879 N75136Montgomery Carson B · Divide, COBuilt 1976 · S/N 28-7690300 N75138High Island Seamless Inc · Gaylord, MNS/N 28-7690302 N7513JHenslin Maja Blu · Wyoming, MNBuilt 1968 · S/N 28R-30880 N75151Olsen Aviation LLC · Atlantic, IABuilt 1976 · S/N 28-7690304 N7515JCrock Brent S · Enterprise, ALBuilt 1968 · S/N 28R-30882 N75165Maple Shores LLC · Helena, MTBuilt 1976 · S/N 28-7690305 N75169Flight School Inc · Spring, TXBuilt 1976 · S/N 28-7690306 N7516JBeard Don Ricarde · Rockledge, FLS/N 28R-30883 N75179K4-S Flight Training LLC · Santa Rosa, CABuilt 1976 · S/N 28-7690308 N7517JWright Aviation LLC · San Francisco, CABuilt 1968 · S/N 28R-30884 N7518JEsposito Michael I · Raleigh, NCBuilt 1968 · S/N 28R-30886 N75190FAA Flying Club Inc · Atlantic City, NJBuilt 1976 · S/N 28-7690309 N75193Groton Flyers LLC · Bozrah, CTBuilt 1976 · S/N 28-7690311 N751ADPeters Abraham · Copeland, KSBuilt 2002 · S/N 0313 N751APAmdent Air LLC · Wyomissing, PABuilt 2005 · S/N 1446 N751BSVenture North Aviation LLC · Cloquet, MNBuilt 2025 · S/N 2881878 N751CCMenlo Aviation LLC · Camden, DEBuilt 2023 · S/N 4636831 N751LBN6105s LLC · Norwood, NCBuilt 2005 · S/N 3246228 N751PCVenture North Aviation LLC · Cloquet, MNBuilt 2023 · S/N 28020103 N751WTVenture North Aviation LLC · Cloquet, MNBuilt 2022 · S/N 2881584 N751YZVenture North Aviation LLC · Cloquet, MNBuilt 2023 · S/N 2881630 N75211Sikes Allen E · Hogansville, GABuilt 1976 · S/N 28-7690312 N75217Taughannock Aviation Corp · Ithaca, NYBuilt 1976 · S/N 28-7690313 N7521JDemarest Graham T · Dallas, ORBuilt 1968 · S/N 28R-30890 N75239Tumbleweed Aviation LLC · Janesville, WIBuilt 1976 · S/N 28-7690316 N7523JWilson Gregory Robert · Templeton, CAS/N 28R-31100 N75254Meyer Larry · Brush, COBuilt 1976 · S/N 28-7690317 N75255Jackson Christopher · Clearwater, FLBuilt 1976 · S/N 28-7690318 N7525JFosdick Trevor · Aldie, VABuilt 1968 · S/N 28R-30895 N7526JWings Over Texas Holdings LLC · Denton, TXS/N 28R-30897 N75276Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690320 N75277Columbus Paul S · Laguna Beach, CABuilt 1976 · S/N 28-7690321 N7527JOlivia Lawrence J · Memphis, NYBuilt 1968 · S/N 28R-30898 N7528JKlevorn Edward D · Lake Saint Louis, MOBuilt 1968 · S/N 28R-30899 N75290Barfield Daniel Malcolm · Cartersville, GABuilt 1976 · S/N 28-7690323 N75292N75292 LLC · Statesville, NCBuilt 1976 · S/N 28-7690324 N752BEvans Michael R · Henderson, NVBuilt 2008 · S/N 3157 N752CTScott Anthony · Frisco, TXBuilt 2008 · S/N 3290 N752DSCoutale Inc Trustee · Wilmington, DEBuilt 2007 · S/N 40.752 N752MMMc Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 4697192 N752NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881031 N752RASmtm Holdings Inc · Wilmington, DEBuilt 1989 · S/N 2841203 N752SBKevu Aviators LLC · Maryville, MOBuilt 2003 · S/N 0773

Back to AD 2008-06-28 R1