Registered aircraft · 1,017

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:2006-01-11-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:2006-01-11-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:2006-01-11-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:2006-01-11-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:2006-01-11-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:2006-01-11-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.

N145KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2019 N145WAMartinaire Aviation LLC · Addison, TXBuilt 2005 · S/N 208B1145 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N147NCorr Aviation Inc · Oxford, MSBuilt 2021 · S/N 208B5626 N149GJAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N 208B5283 N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083 N152TATuck Aerial Surveys Inc · Big Stone Gap, VAS/N 20800664 N155CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0127 N157HJaars Inc · Waxhaw, NCBuilt 2020 · S/N 20800668 N162GAPa1 208b-0667 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0667 N162SAJoby Aero Inc · Santa Cruz, CABuilt 1996 · S/N 208B0548 N167LHIntercontinental Commercial Aircraft Inc · Morriston, FLNon-citizen corporation, flight hours not reportedS/N 208B1162 N168RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800158 N1714HBlue Flight II LLC · Miami, FLBuilt 2025 · S/N 208B5861 N1789MMjr Aviation Consultants LLC · Clearwater, FLBuilt 2010 · S/N 208B2245 N179SAPriority Air Charter LLC · Kidron, OHBuilt 1997 · S/N 208B0594 N180GCZuni LLC · Kirkland, WABuilt 2009 · S/N 208B2085 N183CTUltimate Resort Vacations Inc · Weston, FLBuilt 2010 · S/N 208B2183 N186SGFeet Wet Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 20800504 N187GCZuni LLC · Kirkland, WABuilt 2010 · S/N 208B2213 N188GCZuni LLC · Kirkland, WABuilt 2010 · S/N 208B2210 N189AROverstreet Investments Inc · Boonville, MOBuilt 2021 · S/N 208B5650 N18NMRrcm Air LLC · Hialeah Gardens, FLBuilt 2016 · S/N 208B5303 N18NRWonderful Pistachios & Almonds LLC · Lost Hills, CABuilt 2018 · S/N 20800610 N18ZKHappy Cat Cay LLC · Coral Gables, FLBuilt 2019 · S/N 208B5513 N190BABering Air Inc · Nome, AKBuilt 2020 · S/N 208B5611 N1910RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 208B5891 N192ALAlm Holdings Delaware 6 LLC · Wilmington, DES/N 208B0385 N192GCMonarch Enterprises Inc · Kirkland, WABuilt 2008 · S/N 208B2026 N194SMSurveying And Mapping LLC · Austin, TXBuilt 2019 · S/N 208B5546 N1966GAir Services International Charters LLC · Fort Lauderdale, FLBuilt 2001 · S/N 208B0927 N196GCZuni LLC · Kirkland, WABuilt 2012 · S/N 208B2353 N1983XSouthern Airways Pacific LLC · Addison, TXBuilt 2003 · S/N 208B1013 N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727 N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725 N200AARad Runner LLC · Newton, NCBuilt 2019 · S/N 208B5501 N200KSKapowsin Air Sports Ltd · Shelton, WABuilt 1986 · S/N 208B0001 N200LFAeromarine Holdings LLC · Waukesha, WIBuilt 1989 · S/N 20800149 N2020QKaravan LLC · Gilford, NHBuilt 2020 · S/N 208B5610 N202HPCalifornia Highway Patrol · Sacramento, CABuilt 2022 · S/N 208B5682 N2069BCopper Mountain Aviation LLC · Anchorage, AKBuilt 2021 · S/N 208B5657 N2069WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 208B5492 N2076RBhms Air LLC · Miami, FLBuilt 2019 · S/N 208B5533 N207RADelta Investment Group LLC · Memphis, TNBuilt 2014 · S/N 208B5098 N208Jmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 2002 · S/N 20800363 N208ABSkydive Guam Inc · Barrigada, GUBuilt 2008 · S/N 208B2047 N208AJCessna 2080711 Inc Trustee · Wilmington, DEBuilt 1998 · S/N 208B0711 N208AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 208B0710 N208BMerlin Labs Inc · Boston, MABuilt 2003 · S/N 208B1023 N208BABoeing Co · Renton, WABuilt 2008 · S/N 208B2027

Back to AD 2006-01-11 R1