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.

N351WTFree Bird Air LLC · Raymond, NEBuilt 1996 · S/N 4636071 N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350 N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462 N352ACFlight Leasing Corp · Wilmington, DEBuilt 2006 · S/N 2842277 N352BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881692 N352CMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1995 · S/N 4636019 N352DSWesley Flyers Inc · Madison, MSBuilt 2002 · S/N 40.252 N352JAPeterson Erik · Zeeland, MIBuilt 2008 · S/N 421005 N352JSMccormick Kevin · Douglass, TXBuilt 2006 · S/N 42507 N352KPN258wt LLC · Boca Raton, FLBuilt 2019 · S/N 4845 N352MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881441 N352MMWindmill Aviation LLC · Sleepy Hollow, NYBuilt 2021 · S/N 5096 N352MRN352mr LLC · Weldona, COBuilt 2006 · S/N 1782 N352MSRoehrig Bradley · Webster, NYBuilt 2007 · S/N 1802 N352RCN352rc Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0186 N352SRGulf Atlantic Airways Inc · Gainesville, FLBuilt 2006 · S/N 2030 N352VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 28-7690224 N352ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881642 N3530MComer Robert E · Greensburg, INBuilt 1978 · S/N 28-7890309 N35319Yoder Electric Inc · Monticello, GABuilt 1978 · S/N 28-7816607 N35321Manuel Greg R · Pecatonica, ILBuilt 1978 · S/N 28-7816606 N3533MBrowning Gregory S · Deputy, INBuilt 1978 · S/N 28-7890311 N353ACHoffberger Bruce S · Baltimore, MDBuilt 1998 · S/N 2843161 N353BC5101 LLC · Granville, OHBuilt 2002 · S/N 1172 N353BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881747 N353CAAvpal Aviation LLC · Cupertino, CABuilt 2011 · S/N 2088 N353CDSt Croix Leasing LLC · Fredonia, WIBuilt 2004 · S/N 1210 N353CTCoast Cirrus Training LLC · San Diego, CABuilt 2025 · S/N 10732 N353KSReichard Leasing LLC · Harrisburg, PABuilt 2024 · S/N 10212 N353MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881442 N353PGDecarlo Rick P · Minden, NVBuilt 2004 · S/N 1115 N353SBurdick Steven David · Saint Paul, MNBuilt 1968 · S/N 28R-30851 N353ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881643 N3547MBernstein Matthew D · North Charleston, SCBuilt 1978 · S/N 28-7816354 N354BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881777 N354DSRandhawa Sandeep S · Bedford, NHBuilt 2010 · S/N 40.1082 N354EMSrm Aviation Solutions LLC · Richland, WABuilt 2007 · S/N 2634 N354FCBlue Sky November LLC · Mamaroneck, NYBuilt 2020 · S/N 4875 N354MAAir Shares LLC · Casper, WYBuilt 2003 · S/N 2843545 N354MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881501 N354RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4636537 N3552MArcher Enterprises Inc · Sac City, IABuilt 1978 · S/N 28-7890313 N3553MIxi LLC · West Bloomfield, MIBuilt 1978 · S/N 28-7890314 N35590Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8013020 N3559QIndependence Air LLC · Advance, NCBuilt 1979 · S/N 32R-8029022 N3559ULewis Tyler Dean · Bullard, TXBuilt 1979 · S/N 32R-8013018 N3559XSpon Water Consulting LLC · South Beloit, ILBuilt 1979 · S/N 32R-8013019 N355ABXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496093 N355CVertx Fleet Holdings LLC · San Diego, CABuilt 2018 · S/N 4636723 N355DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843843

Back to AD 2008-06-28 R1