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.

N476SRMjd Advisory Services LLC · Atlanta, GABuilt 2007 · S/N 2746 N476TAAtp Taa LLC · Wilmington, DES/N 2881318 N476TKAviation Partners LLC · Mcallen, TXBuilt 2010 · S/N 3667 N476WGTrow Michael P · Seattle, WABuilt 2002 · S/N 0389 N476YTower Aviation LLC · Kalispell, MTBuilt 2007 · S/N 2624 N47702Braudis Russell P · Pittsburg, TXBuilt 1977 · S/N 28-7890120 N47705Tidona Robert J · Berwyn, PABuilt 1977 · S/N 28-7890121 N47706Coast 2 Coast LLC · Pensacola, FLBuilt 1977 · S/N 28-7890122 N4770FHamblen Scott · Tucson, AZBuilt 1976 · S/N 28-7790061 N47714Bradford Matthew Corin · Murrieta, CAS/N 28-7890088 N47718Ap Midway Inc · Palos Hills, ILBuilt 1977 · S/N 28-7816127 N47719Webb Bennie Kenneth · Fitzgerald, GABuilt 1977 · S/N 28-7816128 N47737N47737 Holdings LLC · Gonzales, LABuilt 1977 · S/N 28-7890129 N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132 N47768Registered aircraftBuilt 1977 · S/N 28-7816133 N47771Harris Richard P · Kings Park, NYS/N 28-7890135 N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137 N4777DZulu Aviation Partners LLC · Helena, MTS/N 411081 N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017 N477BJrs Aviation LLC · Falls City, NES/N 441-0055 N477DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1819 N477HCParish Air Inc · San Diego, CABuilt 2003 · S/N 4697171 N477HPWilliams Kerry Brent · Seminole, TXBuilt 2006 · S/N 3257429 N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538 N477MTFirst Lease Inc · Britton, SDBuilt 2008 · S/N 411073 N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200 N477RRadtke Jeffrey A · Norwalk, CTBuilt 2003 · S/N 3232006 N477TWMalibu Aircraft LLC · Scottsdale, AZS/N 4636477 N477UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496450 N477WWCcm Aircraft LLC · Lynn Haven, FLBuilt 2019 · S/N 4770 N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134 N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136 N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139 N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140 N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138 N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139 N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141 N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147 N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151 N47882Trident Aircraft Inc · Easton, MDBuilt 1977 · S/N 28-7816152 N47885Dynasty Adventure Inc · Mentone, CABuilt 1977 · S/N 28-7890148 N47886N47886 LLC · Dover, DEBuilt 1977 · S/N 28-7890149 N47899Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816153 N478AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843746 N478ABM1 Executive Flying LLC · Lewes, DEBuilt 2009 · S/N 411130 N478AVWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2023 · S/N 9175 N478BCBb Co LLC · Englewood, COBuilt 2019 · S/N 2503 N478CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 0400 N478CZKmc Logistics LLC · Franklinton, LABuilt 2023 · S/N 9478 N478DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1820

Back to AD 2008-06-28 R1