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.

N90MGEracare Aviation LLC · Wesley Chapel, FLBuilt 2007 · S/N 2380 N90PHTriple R Spraying LLC · Dumas, TXBuilt 1973 · S/N LW-60 N90SEKelly James D II · San Francisco, CABuilt 1989 · S/N 4622041 N90TJTalcorp Ec Inc · Justin, TXS/N LW-228 N90ZZMckeand Scott · Grant Township, MIBuilt 2005 · S/N 4697223 N9101THahn Derrick J · Combine, TXBuilt 1985 · S/N 28-8690019 N9105QTalon Aviation Of Nc LLC · Winston Salem, NCBuilt 1986 · S/N 3213002 N9105TMcclellan Peter · Altus, OKBuilt 1985 · S/N 32R-8629003 N9105XHedgehopper Flying Club Inc · Springfield, MOBuilt 1986 · S/N 2890006 N9106YRegion Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8616001 N91071Warrior II LLC · Zionsville, INBuilt 1985 · S/N 28-8616004 N91077Brown Patricia L · Destin, FLBuilt 1985 · S/N 28-8690023 N91079Gholson Travis R · Carmi, ILBuilt 1985 · S/N 28-8690024 N9107SMaul Errol T · Ocala, FLBuilt 1986 · S/N 2890010 N9109QBurns Timothy M · Huntington, NYBuilt 1986 · S/N 2890011 N910BHb Air LLC · Arvada, COS/N 2352 N910BBCoughlin Daniel F · Frederiksted, VIBuilt 2008 · S/N 40.910 N910CDDubach Carter Douglas · Norco, CABuilt 2002 · S/N 1247 N910FVip Aviation LLC · Sunrise, FLBuilt 1983 · S/N 34-8333088 N910GTRq Aviation LLC · Matthews, NCS/N 3153 N910KTAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496246 N910MLSegall Aviation LLC · Baltimore, MDBuilt 2008 · S/N 411031 N910MREcho Dynamics · La Mesa, CABuilt 1979 · S/N 28-7990549 N910SGKrs Aviation LLC · Elk Grove Village, ILBuilt 2007 · S/N 2774 N910WMDismore David · Jacksonville, FLBuilt 2013 · S/N 2226 N910WTRhnc Holdings LLC · Wilmington, NCBuilt 2026 · S/N 11591 N9110UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020280 N9110WRg Air LLC · Muscle Shoals, ALBuilt 1986 · S/N 3229002 N9112ZWalters Darren · Overland Park, KSBuilt 1986 · S/N 2890017 N9114DMacair Aviation LLC · Xenia, OHBuilt 1987 · S/N 2890032 N9115QSoto Daniel-Rey · Smiths Station, ALBuilt 1987 · S/N 2890033 N9118SSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 2816010 N9118ZFlying Mermaid LLC · Aiea, HIBuilt 1986 · S/N 2890022 N911DWOcmulgee Outdoors Inc · Hazlehurst, GABuilt 2000 · S/N 3257133 N911HEHigh Expectations LLC · York, SCBuilt 2025 · S/N 10610 N911JCAva Leasing LLC · Bay Harbor Islands, FLBuilt 2021 · S/N 4636783 N911KESr Aviation LLC · Shady Shores, TXBuilt 2008 · S/N 3187 N911KTStar-Aveo Inc Trustee · Wilmington, DEBuilt 2007 · S/N 40.787 N911PFColemanation Investments LLC · Prosper, TXBuilt 2018 · S/N 2462 N911PJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410146 N911TCMorcomb LLC · Bonita Springs, FLBuilt 2006 · S/N 4697238 N911TKAbsolute Precision Chiropractic Inc · Jesup, GABuilt 2004 · S/N 1001 N911TWStepp Dave A · Ruidoso, NMBuilt 2008 · S/N 3172 N9123XHeavenly Realms Aviation LLC · Grand Junction, COBuilt 1987 · S/N 3229003 N9127NKohler David W · Portland, INBuilt 1993 · S/N 2890175 N9128WBoiler Express LLC · Gouldsboro, PABuilt 1987 · S/N 3213005 N9128ZRpd Aviation LLC · Saint Joseph, MNBuilt 1987 · S/N 3213008 N912ARMicam Development LLC · Weatherford, TXBuilt 2007 · S/N 3257445 N912AVAeropus LLC · Rancho Santa Fe, CABuilt 2008 · S/N 411006 N912BGPagano Robert L · Massapequa, NYFirst renewal noticeS/N 1220

Back to AD 2008-06-28 R1