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.

N8125DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8029014 N8125EEmb Aero LLC · Lakeland, FLBuilt 2003 · S/N 0671 N8125LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 44-8095010 N8125YGlass Jody L · Indianapolis, INBuilt 1979 · S/N 28-8016146 N81260Trusty Archer LLC · Ann Arbor, MIBuilt 1979 · S/N 28-8090155 N8126GTwylia J Sekavec LLC · Brownell, KSBuilt 2003 · S/N 0672 N8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIBuilt 1979 · S/N 28-8016149 N8126XB2fh Ltd · Allentown, NJBuilt 1979 · S/N 28-8090154 N8127AOpm Partners LLC · Kalispell, MTBuilt 2003 · S/N 0653 N8127MBravo Whiskey Aviation LLC · Louisville, KYBuilt 2003 · S/N 0784 N8127ZCrawford Oil Co Inc · Hayti, MOBuilt 1979 · S/N 32R-8029017 N8128BMcguinnis Joseph G · Scottsdale, AZS/N 32R-8029018 N8128XSimmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 28-8016153 N8129HAdventure Bound LLC · Saint Paul, NEBuilt 1980 · S/N 32R-8013054 N8129JFunk Wendell L · Lancaster, PABuilt 1982 · S/N 28-8290093 N8129MAviation Consulting Expertise LLC · Fairfax Station, VABuilt 1982 · S/N 28-8290094 N812ATHaverlah Dennis W · Cedar Park, TXS/N 28-7716211 N812BEHubbell Aero LLC · Fairfax, VABuilt 1999 · S/N 3257115 N812BTP D Deshotels Equipments Co LLC · Plaucheville, LABuilt 2015 · S/N 4272 N812CDMirot Max S · Hereford, AZBuilt 2008 · S/N 3123 N812CSBeck Michael W · Woodbridge, VABuilt 2013 · S/N 3931 N812DBJets Holdings LLC · Johns Island, SCBuilt 2007 · S/N 2399 N812DKTranscendent Enterprises Inc DBA · Pine Grove, CABuilt 2005 · S/N 3257397 N812DMRomanair Wdr Inc · Winder, GABuilt 2004 · S/N 0863 N812DWAir/Land Ventures Two LLC · Hamilton, MTBuilt 2001 · S/N 0124 N812JPJpd Executive Travel LLC · Matthews, NCBuilt 2007 · S/N 2869 N812MFj Aviation LLC · Texarkana, TXBuilt 2000 · S/N 32-57162 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N812NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881046 N812PVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2007 · S/N 41737 N812SEPegasus LLC · Birmingham, ALBuilt 2006 · S/N 2152 N812TRKahube Aero LLC · Nephi, UTBuilt 2022 · S/N 8547 N812TWTaiclet David · Coral Gables, FLBuilt 2015 · S/N 4189 N8131EInfratech Corp · Kennesaw, GABuilt 1982 · S/N 34-8233093 N8131RPaphos Airways LLC · Farmingdale, NYBuilt 1979 · S/N 28-8016158 N8131WGaudette Philip C · Woodstock, CTS/N 28-8016159 N8131XC&W Leasing · Cedar Rapids, IAS/N 28-8016160 N81321Treacy Richard K · North Massapequa, NYBuilt 1982 · S/N 28-8216113 N81327Roman Maritza Torres · Toa Alta, PRBuilt 1980 · S/N 28-8016164 N8132BOptisure Risk Partners LLC · Manchester, NHBuilt 1979 · S/N 28-8090164 N8132RTwo Brothers Acquisitions LLC DBA · Perris, CAS/N 28-8090166 N8133CCarter Marl · Coburg, ORBuilt 1975 · S/N 28-7690104 N8133ELane Community College · Eugene, ORBuilt 1980 · S/N 28-8016167 N8133JWarrior Aviation LLC · Stanford, KYBuilt 1979 · S/N 28-8016170 N8133ZLupa Holdings LLC · New York, NYBuilt 2003 · S/N 0673 N81344November 46a Leasing Inc · St Augustine, FLBuilt 1980 · S/N 28-8016169 N8135AB And S Aviation LLC · Hamilton, ILBuilt 2003 · S/N 0674 N8135CCoverdale Aviation LLC · Ellendale, DEBuilt 1979 · S/N 28-8016173 N8135GMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016175 N8135PStein David J · New Port Richey, FLBuilt 1979 · S/N 28-8016176

Back to AD 2008-06-28 R1