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.

N35GMSt Cloud Flying Club LLC · Saint Cloud, MNBuilt 2003 · S/N 0478 N35KLR Ken Lord Md Pc · St George, UTBuilt 2022 · S/N 4636808 N35PABorzoya Aero Group Inc · Slatington, PABuilt 1977 · S/N 28-7716087 N35PTN523rs LLC · Middletown, DEBuilt 2021 · S/N 2785 N35SDN35sd LLC · Latham, NYBuilt 2024 · S/N 9937 N35WCHawley Flying Club Inc · Fargo, NDBuilt 1979 · S/N 28-8016180 N35XPFletcher Lance · Germantown, OHBuilt 2011 · S/N 3716 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913 N360CWassup Homes LLC · Wilmington, DEBuilt 2007 · S/N 2562 N360CD360cd LLC · Eagle, IDBuilt 2009 · S/N 3516 N360CFCoast Flight Training And Management Inc · San Diego, CAS/N 44-7995307 N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060 N360LULewis University · Romeoville, ILBuilt 2021 · S/N 4496522 N360LVJb Acquisitions LLC · Gonzales, LABuilt 2008 · S/N 3272 N360SUOklahoma State University · Stillwater, OKBuilt 2019 · S/N 2525 N360WLLaughlin Linda · Bluff Dale, TXBuilt 2002 · S/N 0216 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619 N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319 N361JBCarroll Farm Management Company · Carthage, ILBuilt 2005 · S/N 1253 N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741 N361KMMclain Kevin A · Stoddard, WIBuilt 2015 · S/N 4212 N361LBMiller Steven D · Edinburg, PABuilt 2003 · S/N 42010 N361MEN361me LLC · Blanding, UTBuilt 1978 · S/N 28-7890361 N361MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881588 N361NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881827 N361TA466m LLC · Evansville, INBuilt 2008 · S/N 3325 N361WA32 Poco LLC · Dover, DEBuilt 1999 · S/N 3257121 N361ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881644 N362Andi 362 LLC · Duncan, SCBuilt 1975 · S/N 28-7690096 N36209Indian Hills Community College · Ottumwa, IABuilt 1978 · S/N 28-7816622 N3621XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881010 N36276Gronning Skyler · Westby, WIBuilt 1978 · S/N 28-7816624 N36281Hedgehog Management LLC · Salem, OHBuilt 1978 · S/N 28-7890503 N362ABReynolds Bruce G · Wausau, WIBuilt 1980 · S/N 32R-8029068 N362BZTibara LLC · Newark, DEBuilt 2024 · S/N 9801 N362CDBmg Adventures LLC · Decatur, TXBuilt 2005 · S/N 1392 N362CPLare Robert W Jr · Shreveport, LABuilt 2008 · S/N 3048

Back to AD 2008-06-28 R1