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.

N9228NEncore Jet Management LLC · San Antonio, TXBuilt 1993 · S/N 3213059 N9229BSsb Holdings LLC · Lake Wales, FLBuilt 1993 · S/N 3213060 N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391 N922BPTeam Leclaire LLC · Naples, FLBuilt 2018 · S/N 4613 N922HPColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1978 · S/N 441-0027 N922KAAtlas Aviation LLC · Buckhannon, WVBuilt 2007 · S/N 2390 N922MHRicotta Paul J · Newton, MABuilt 2005 · S/N 1281 N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004 N922SE922se LLC · Fort Collins, COBuilt 2006 · S/N 2224 N922SRBorich Air LLC · Austin, TXBuilt 2003 · S/N 0461 N922TNWings Melbourne LLC · Melbourne, FLBuilt 2007 · S/N 2529 N922TWCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11621 N922VGBttw Holdings LLC · Newark, DEBuilt 2016 · S/N 4393 N922WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10284 N92303Herman M Flink Inc · Mount Dora, FLBuilt 1993 · S/N 3213061 N9233ZCalmwinds LLC · Middletown, DEBuilt 1993 · S/N 3213062 N9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232 N92358Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1993 · S/N 4622147 N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392 N9235QInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N 3213072 N9236JThunderbird Air LLC · Grand Rapids, MIBuilt 1993 · S/N 3213067 N9236NWilliams Robert J · Sewickley, PABuilt 1993 · S/N 3213068 N9236VYeske Brock Ray · Peoria, ILBuilt 1993 · S/N 3213069 N9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123 N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233 N9239DMisson Aviation LLC · Lima, OHBuilt 1994 · S/N 3213071 N9239NRd Aviation LLC · Fort Lauderdale, FLBuilt 1993 · S/N 3213070 N923ABFloralyn Aviation LLC · East Hampton, NYBuilt 2017 · S/N 4472 N923AJRegistered aircraftBuilt 2012 · S/N 3892 N923ASDjp Properties LLC · Selma, CABuilt 1979 · S/N BB-541 N923BBInnovative Flight Systems LLC · Lewes, DEBuilt 2013 · S/N 2231 N923CMContinental Aerospace Technologies Inc · Mobile, ALBuilt 2023 · S/N 9312 N923DSExecu-Air LLC · Apopka, FLS/N 40.979 N923GTQuinby Tom · Memphis, TNS/N 4535 N923JWD&L Aviation LLC · Hillsboro, MOBuilt 2006 · S/N 1700 N923MSCypress Innovations LLC · Lindenhurst, ILBuilt 2005 · S/N 1743 N923PMNeuhaus George W · Skokie, ILBuilt 2005 · S/N 41526 N923PTMiller Light Investments LLC · Mcalester, OKBuilt 2017 · S/N 4531 N923WSHmsi Air Inc · Castle Rock, COBuilt 2004 · S/N 1052 N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234 N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254 N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149 N9246QSullivan Daniel J · Medina, MNBuilt 1994 · S/N 3448045 N9248KGerstner Michael J · Ola, ARBuilt 1976 · S/N 28-7690236 N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483 N924BMAviation Industries LLC · Aurora, ILBuilt 2015 · S/N 4178 N924CDSunshine Holding LLC · Danbury, CTBuilt 2002 · S/N 0334 N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057 N924DDSkyhigh317 Inc · Kingston Springs, TNBuilt 2004 · S/N 1443 N924DSSanta Barbara Aviators LLC · Santa Barbara, CABuilt 2002 · S/N 40.224

Back to AD 2008-06-28 R1