Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N97111Plane & Simple LLC · Aurora, OHBuilt 2012 · S/N 40.1166 N9711SAtlas Aviation LLC · Buckhannon, WVBuilt 2006 · S/N 1693 N9715CBragg Larry M · Kansas City, MOBuilt 1978 · S/N 28-7816520 N9717CMiloud Chadd · Fort Worth, TXBuilt 1978 · S/N 28-7816522 N971ABPiper Aircraft Inc · Vero Beach, FLS/N 28010092 N971ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916188 N971CDHodges Vehicle Rentals LLC · West Branch, MIBuilt 2006 · S/N 1813 N971DSGville Flyers I LLC · Gainesville, FLS/N 40.671 N971PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 4496031 N971RDMouton Chad A · Houston, TXBuilt 2005 · S/N 40.508 N971SRInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1726 N971WCCavorite Aviation LLC · Lehi, UTBuilt 2002 · S/N 2843525 N9720CCooper Richard W Trustee · Indianapolis, INBuilt 1978 · S/N 28-7890440 N9721KJet Time Consulting LLC · Gilbert, AZBuilt 1976 · S/N 28-7690277 N9724KGoodwin Thomas R · Martinsville, INBuilt 1976 · S/N 28-7690278 N972BCN972bc LLC · Kennesaw, GABuilt 2025 · S/N 10776 N972BRArrow John · Austin, TXBuilt 2005 · S/N 1712 N972CPlainfield Aviation Inc · Plainfield, ILBuilt 2002 · S/N 2843538 N972CDCranford Michael Glen · Caddo, OKBuilt 2005 · S/N 1562 N972CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3162 N972DDLakala Aviation Inc · Vicksburg, MIBuilt 2014 · S/N 4636637 N972JBMotley Kyle · Brentwood, TNBuilt 2006 · S/N 2267 N972JHLynetha Aviation LLC · Oshkosh, WIBuilt 2014 · S/N 4059 N972JMUltimate Holdco Inc · Mount Airy, NCBuilt 2002 · S/N 0212 N972PAPalomar Aviation LLC · Carlsbad, CABuilt 2021 · S/N 2721 N972TBLotane Troy Randall · Marathon, FLS/N 3778 N972TFAir Fleet Holdings LLC · Missoula, MTS/N 2881595 N973CDByrd Jack P · Cleveland, TNBuilt 2006 · S/N 1806 N973CPTarpon Air LLC · St Pete Beach, FLBuilt 2005 · S/N 3255030 N973DMWingman Aviation LLC · King William, VABuilt 2011 · S/N 2118 N973KBKbb Aviation LLC · Carmichael, CABuilt 2024 · S/N 9969 N973KP898 Air LLC · Indianapolis, INBuilt 2007 · S/N 2697 N973PAPalomar Aviation LLC · Carlsbad, CABuilt 2020 · S/N 2603 N973SDCloud9 Aviation LLC · Wilmette, ILS/N 3755 N9745CWashington State Community College District 17 · Spokane, WABuilt 1978 · S/N 28-7816523 N974ABPiper Aircraft Inc · Vero Beach, FLS/N 28010093 N974ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916126 N974CT&W Rentals LLC · Houma, LABuilt 2007 · S/N 3257477 N974GShea Joseph W · Omaha, NES/N 32R-8313016 N974MATerriair Aviation LLC · Littleton, COS/N 28-8116288 N974PAPalomar Aviation LLC · Carlsbad, CABuilt 2019 · S/N 2511 N974RKGubbels Jared John · Norfolk, NES/N 1864 N974SRFishes And Loaves LLC · Helena, MTBuilt 2007 · S/N 2729 N974WFVictory Aviation LLC · Winchester, VABuilt 2006 · S/N 42527 N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524 N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121 N975BBSeahawk Aviation LLC · Bradenton, FLBuilt 2026 · S/N 11076 N975BESaucerman & Company LLC · Hampstead, NCBuilt 1996 · S/N 3246040 N975CWMarvphanie Equipment LLC · Byron, GABuilt 2002 · S/N 0424 N975DSJpm Aviation LLC · Irvine, CABuilt 2009 · S/N 40.1065

Back to AD 2008-06-28 R1