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.

N391CCSimply Living LLC · Fort Myers, FLS/N 4697147 N391CPMkns 319cp LLC · Kalispell, MTBuilt 2008 · S/N 3072 N391DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843849 N391KCAig Aeronautics LLC · Guaynabo, PRBuilt 2005 · S/N 3257391 N391TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10912 N391WHSheppard Harold Jr DBA · Riverton, WYBuilt 1968 · S/N 28R-30934 N3921TLittlehailes Roderick A Trustee · Solvang, CAS/N 28R-30258 N3924TRaw Racing Inc · Puyallup, WABuilt 1967 · S/N 28R-30262 N3925TElevation Air LLC · Amelia, OHBuilt 1967 · S/N 28R-30263 N3926TNewton Aviation LLC · Atlanta, GAFirst renewal noticeBuilt 1967 · S/N 28R-30264 N3928BKellner Eric · Upland, CABuilt 2004 · S/N 0917 N3928TBarnett Rodney · Rockwood, TNBuilt 1967 · S/N 28R-30267 N392DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843850 N392HPAd Flight Training LLC · Altamont, NYBuilt 2005 · S/N 3257387 N392MASch Aviation Inc · Sporle Kings LynnBuilt 2018 · S/N 4697642 N392TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10916 N3931THall Charles H · Belleville, MIBuilt 1967 · S/N 28R-30270 N3932TAhles David R · Tellico Plains, TNBuilt 1967 · S/N 28R-30271 N3935YShewchuk Bailey · KelownaBuilt 2014 · S/N 4636620 N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386 N3936TGreen Castle Aero Club Ltd · Oxford, IABuilt 1967 · S/N 28R-30277 N39393International Air Services Inc Trustee · Carson City, NVS/N 3449485 N3939TDespins David R · Gray, MES/N 28R-30281 N393BTPiper Aircraft Inc · Vero Beach, FLS/N 28010094 N393CDBowtie Properties LLC · Dadeville, ALBuilt 2005 · S/N 1478 N393CPN393cp LLC · Manteca, CABuilt 2008 · S/N 1924 N393DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843851 N393DSRut N Strut Aviation LLC · Shelbyville, KYBuilt 2023 · S/N 9499 N393GMFly Illini LLC · Indianapolis, INBuilt 2017 · S/N 4474 N393JM3b Family LLC · Dover, DEBuilt 2015 · S/N 4287 N393JWGeneration Jets LLC · Denison, TXBuilt 1977 · S/N BB-292 N393MMN393mm LLC · Stillwater, OKBuilt 2000 · S/N 3257168 N393TSTexas Southern University · Houston, TXBuilt 2025 · S/N 11018 N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388 N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285 N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660 N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463 N3945TElsinger Vincent R · Pierre, SDS/N 28R30288 N3946MPlane Flt LLC · Broken Arrow, OKBuilt 2014 · S/N 4636621 N3946TPotter Allen W · Clinton Corners, NYBuilt 1967 · S/N 28R-30289 N39472Moore Tucker S · Keswick, VABuilt 1978 · S/N 28-7816662 N3948TSchmidt Stephen M · Tipp City, OHS/N 28R-30291 N39496Texter John F · Saint Ignace, MIBuilt 1978 · S/N 28-7890536 N3949THathaway Devon Scott · Buna, TXS/N 28R-30292 N394CCRoco Air LLC · San Antonio, TXBuilt 2004 · S/N 1395 N394CPN394cp LLC · Pinehurst, NCBuilt 2008 · S/N 3079 N394DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843858 N394DSP&R Operations Ltd · Muscatine, IABuilt 1980 · S/N 28-8116040 N394HPMms Aviation LLC · Muscle Shoals, ALBuilt 1993 · S/N 3213066 N394JMHigh Steaks Aviation LLC · Ragley, LABuilt 2019 · S/N 4839

Back to AD 2008-06-28 R1