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.

N42LGArgand Aircraft LLC · Chamblee, GABuilt 2024 · S/N 9875 N42PCKrohn Aviation LLC · Springfield, OHBuilt 1973 · S/N LW-85 N42PYArtemis Aviation LLC · Houston, TXBuilt 2022 · S/N 8941 N42RTMonette Michael · Dallas, TXBuilt 1983 · S/N 32R-8329030 N42TJShark Vision LLC · Palm Harbor, FLBuilt 2017 · S/N 4507 N42VNHelm Michael C · Delray Beach, FLBuilt 2005 · S/N 40.536 N42VRBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1673 N42VUHuff Air LLC · Uvalde, TXBuilt 2018 · S/N 2440 N42ZDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1976 · S/N BC28 N42ZNHuntsville Flyers LLC · Owens Cross Roads, ALBuilt 2001 · S/N 0042 N4300SLcc West LLC · Freehold, NJS/N 28-8316064 N4300UUltimate Thermal Inc · Omaha, NES/N 28-8390053 N43010Nahigian J Victor · Weston, MABuilt 1983 · S/N 34-8333075 N4301NStoddard Don · Great Falls, MTS/N 32R-8329025 N4302NAtlantic Aircraft Holdings LLC · Bohemia, NYS/N 34-8333073 N4302TRiley Thomas J · West Grove, PABuilt 1983 · S/N 28-8316065 N43037Miloud Chadd K · Fort Worth, TXBuilt 1983 · S/N 28-8316068 N4303PBenham Properties LLC · Sullivan, INS/N 32R-8313020 N4303WDickhead Aviation LLC · Smithfield, NCBuilt 1983 · S/N 34-8433016 N4304DPops Aviation LLC · Pace, FLS/N 28-8316070 N4304LExplorer Sky Ventures LLC · Newark, DEBuilt 1983 · S/N 32R-8329027 N43055Plain Plane Partners LLC · Wilmington, DEBuilt 1983 · S/N 28-8390066 N43056Lucier Laura M · Houston, TXBuilt 1983 · S/N 28-8390067 N43060Jefferson City Aviation Inc · Jefferson City, MOBuilt 1983 · S/N 28-8316074 N4306BPv Rec Flight LLC · West Chester, PABuilt 1983 · S/N 28-8390068 N4306VArchwell Aviation LLC · Glendale, AZS/N 32R-8329028 N43074Project 70 LLC · Broomall, PABuilt 1983 · S/N 32R-8313023 N4307MCannon Mark C · Shelbyville, TNBuilt 1983 · S/N 28-8316076 N4307YShoulder Solutions LLC · Spotsylvania, VABuilt 1983 · S/N 32R-8313022 N4308KPetsche Renee A · Round Rock, TXFirst renewal noticeBuilt 1983 · S/N 28-8316082 N4308PPilots Flying School LLC · Englishtown, NJBuilt 1983 · S/N 28-8390069 N43091Reid Royce · Ferndale, WABuilt 1983 · S/N 28-8390076 N43095Rogers Danny · Florence, KYBuilt 1983 · S/N 28-8390077 N4309XFizer Charles Sutton IV · Orlando, FLBuilt 1983 · S/N 28-8316086 N430DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816517 N430GWAvtran LLC · Clayton, MOBuilt 2014 · S/N 4692208 N430JPAuchincloss John W · Weston, CTBuilt 2005 · S/N 40.507 N430LPDiamond D Aviation LLC · Northford, CTBuilt 2017 · S/N 4454 N430MCDenault John B III · Fullerton, CABuilt 1981 · S/N BB-904 N430NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010017 N430RMRocky Mountain College · Billings, MTBuilt 2006 · S/N 2843625 N430SUBoelte Aviation LLC · Edmond, OKBuilt 2022 · S/N 8668 N430TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881089 N430ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881671 N4311ALopez Jennifer L · Fort Rucker, ALBuilt 1983 · S/N 28-8316089 N4311VWayne Braden M · Greenbrier, ARBuilt 1983 · S/N 28-8390079 N43124Beale Air Force Base Aero Club · Beale Afb, CABuilt 1983 · S/N 28-8316094 N43128United States Air Force Owner · Hanscom Afb, MABuilt 1983 · S/N 28-8316095 N4312FUniversal Aviators Academy Inc · El Monte, CABuilt 1977 · S/N 287790010 N4312PSkypro Industries Inc · Jacksonville, FLS/N 28-8316093

Back to AD 2008-06-28 R1