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.

N433TMChristensen Michael S · Mesa, AZBuilt 2002 · S/N 0144 N433WSAlpha Ingredients Inc · Belle Mead, NJS/N 0254 N43408Miloud Chadd K · Fort Worth, TXBuilt 1984 · S/N 28-8416048 N4341DFewless Aviation LLC · Coopersville, MIS/N 32R-8413009 N43428Anders Judd E · Reno, NVBuilt 1984 · S/N 32R-8429007 N4342CTwin City Air Activities Inc · Rock Falls, ILBuilt 1984 · S/N 28-8416051 N4342YSaratoga Flyers LLC · West Palm Beach, FLS/N 32R-8413010 N4343PEnvironmental Enterprises Inc · Cincinnati, OHBuilt 1984 · S/N 34-8433034 N4344PAbele Benjamin · Lexington, NCBuilt 1984 · S/N 28-8490051 N43450Sidhu S Karmendra · Lattingtown, NYBuilt 1984 · S/N 32R-8413011 N43455Siskiyou Aero LLC · Ashland, ORBuilt 1984 · S/N 28-8416055 N4345BHamilton Justin M · Knightsen, CABuilt 1984 · S/N 28-8416057 N4345CAeroservice Aft Corp · Miami, FLS/N 28-8416059 N4345GG & M Aircraft Inc · Wheat Ridge, COBuilt 1984 · S/N 28-8416061 N4346DLane Community College · Eugene, ORBuilt 1984 · S/N 28-8416111 N4347DAviation Flight Services Inc · Cumming, GABuilt 1984 · S/N 28-8416081 N4347GPurdue Pilots Inc · West Lafayette, INBuilt 1984 · S/N 28-8416062 N4347HKillian Regina · Prosper, TXBuilt 1984 · S/N 28-8416063 N4347KRegistration Pending · Augusta, KSRegistration pendingBuilt 1984 · S/N 28-8416064 N4348FRegistered aircraftBuilt 1976 · S/N 28-7790018 N4348YFlamingo Express LLC · Jacksonville, FLBuilt 1984 · S/N 34-8433040 N4349FStriegel Jory D · Washington, DCS/N 28-7790019 N4349LParker Air LLC · Mobile, ALBuilt 1984 · S/N 28-8416068 N4349YSpence Willard J · Davin, WVBuilt 1984 · S/N 28-8416071 N434BZAvp 2 Aviation LLC · Wayne, PABuilt 2019 · S/N 2505 N434CDFlycarolina LLC · Concord, NCBuilt 2005 · S/N 1514 N434KBConnecting Aviators LLC · Katy, TXBuilt 2026 · S/N 11300 N434MRiptide Aviation LLC · Sheridan, WYBuilt 2026 · S/N 11322 N434MMMlc Aviation LLC · Inver Grove, MNBuilt 2007 · S/N 2643 N434PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496064 N434SPittsburg Flyers LLC · Pittsburg, KSBuilt 1981 · S/N 28-8290085 N434SRMiller Richard Francis · Waxhaw, NCBuilt 2007 · S/N 2557 N434TBFlightworks LLC · Crozet, VAS/N 0290 N4351KBaumgartner Trucking Inc · Lafayette, INBuilt 1984 · S/N 32R-8413012 N4351UHosteter Aviation LLC · Gentry, ARBuilt 1984 · S/N 32R-8413013 N4352DAshdown Adrian · Canandaigua, NYBuilt 1984 · S/N 28-8416073 N4352GBouza Mario · Santa Clara, CABuilt 1984 · S/N 28-8416074 N4353LSummit Flight Academy LLC · Peculiar, MOBuilt 1984 · S/N 28-8490062 N4356BVu Ai T · Aiea, HIS/N 28-8490089 N4358DAir Waves Saratoga LLC · Omaha, NEBuilt 1984 · S/N 32R-8413015 N4358TGriffith Aviation Inc · Griffith, INBuilt 1984 · S/N 28-8416040 N4359CSmith Kevin Lee · Peachtree City, GAS/N 28-8416088 N4359YSportsman Airpark Inc · Newberg, ORBuilt 1984 · S/N 28-8490073 N435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0836 N435CPNext Century Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 3264 N435EFFlyboyz3 LLC · Helena, MTBuilt 2025 · S/N 11045 N435HPOne2one LLC · Westminster, CABuilt 2008 · S/N 4692035 N435JBCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11558 N435NDPars Avn Corp · Wilmington, DEFirst renewal noticeBuilt 2006 · S/N 2842270 N435PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496070

Back to AD 2008-06-28 R1