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.

N28088Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881393 N2808LNtss LLC · Henderson, NVBuilt 2015 · S/N 4636676 N2809Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010051 N28090Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881394 N28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2020 · S/N 2881395 N28096Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881405 N28098Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881406 N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511 N280BGD&J Aviation LLC · Gotha, FLBuilt 2002 · S/N 2842167 N280CDWelling Lynn E · El Cajon, CABuilt 2005 · S/N 1411 N280CPAi Aviators LLC · Vancouver, WABuilt 2008 · S/N 3222 N280DSQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 40.955 N280FGFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496525 N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733 N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043 N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219 N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329 N280LVagiunic David · Ridgewood, NYBuilt 2002 · S/N 0154 N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230 N280RATechnology Service Corp · Arlington, VABuilt 1975 · S/N BB-53 N280SREdge Forward LLC · Thermopolis, WYBuilt 2007 · S/N 2800 N28110Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496513 N28114Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496514 N28115Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496515 N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052 N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728 N2815FKlopping William E · Apple Valley, CAS/N 28-7916438 N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451 N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452 N2816PNetz Aviation LLC · Grand Ledge, MIS/N 28-7990453 N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455 N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456 N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459 N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462 N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466 N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467 N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469 N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280 N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665 N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111 N281CPJust Plane Insane LLC · Missouri City, TXBuilt 2008 · S/N 3181 N281DDRomeo Hotel LLC · Black Hawk, COBuilt 2006 · S/N 4697262 N281DSBoughton Kyle · Mckinleyville, CABuilt 2007 · S/N 2534 N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323 N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130 N281MFFisher Robert · Durham, NCBuilt 2025 · S/N 10441 N281SRLawyers Real Estate Services LLC · Hondo, NMBuilt 2007 · S/N 2810 N281TWSkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881091 N282Sh1p Holdings LLC · Wichita, KSBuilt 2023 · S/N 9446 N2822STwo Two Sierra LLC · Austin, TXBuilt 1979 · S/N 28-7990470

Back to AD 2008-06-28 R1