Registered aircraft · 16,290

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.

N122HBBych Robert Peter Trustee · Chandler, AZS/N 1762 N122HDDadwal Aviation LLC · Seaside, CABuilt 2020 · S/N 4921 N122KMBruce Mellor Inc · Escalon, CABuilt 2001 · S/N 0036 N122MG122mg Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1250 N122MXAce Aviation LLC · Parkersburg, WVBuilt 2017 · S/N 2347 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2797 N122RSN864sr LLC · Phoenix, AZBuilt 2008 · S/N 3241 N122VSOrwin LLC · Winter Park, FLBuilt 2014 · S/N 4155 N122WDSazerac Air LLC · Bedford, NHBuilt 1997 · S/N 4636084 N122ZTJdw Aviation Inc Trustee · Wilmington, DEBuilt 2020 · S/N 4882 N1230UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020277 N12354Spencer Christopher · Voorheesville, NYBuilt 1968 · S/N 28R-30607 N1235LN1235l LLC · Tallahassee, FLBuilt 2007 · S/N 41741 N1239ZDerrickson Bryan C · Lewes, DEBuilt 2009 · S/N 411124 N123ANSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 1379 N123AXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1996 · S/N 3246060 N123BMMb700pv LLC · Greenwich, CTBuilt 2009 · S/N 3513 N123CGLmadif LLC · Kaukauna, WIBuilt 2003 · S/N 1317 N123CMSweet Wings Inc · Bethlehem, PABuilt 1977 · S/N 28-7790575 N123DUInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 287716195 N123DVInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 1313 N123ETMike Charlie Inc · Lewes, DEBuilt 2024 · S/N 9990 N123FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496648 N123GCParsons John · Winter Park, FLS/N 28-7990583 N123GKKolis George J · Pennsauken, NJBuilt 1980 · S/N 28-8016359 N123HBValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0510 N123HLEfinance LLC · Wichita, KSS/N 441-0010 N123KRRuhlin Thomas J · Lakewood Ranch, FLBuilt 1977 · S/N 28-7716242 N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104 N123MZMj Aviators LLC · Portland, ORBuilt 2010 · S/N 40.1070 N123NADecker Family Aviation LLC · Conroe, TXBuilt 2005 · S/N 40.484 N123TEVirgil W Young Jr Pa · North Little Rock, ARBuilt 1994 · S/N 4622169 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N123TSRyen Air LLC · Wilmington, DEBuilt 2005 · S/N 4697219 N123TVIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.432 N123UASchlabach Sharon · Lakewood Rch, FLBuilt 1990 · S/N 28-90137 N123VGCrepco LLC · Benton, ARBuilt 2002 · S/N 0383 N123XCEiger Aviation LLC · Woodstock, ILBuilt 2002 · S/N 0345 N123ZMAircraft Solutions LLC · Spokane, WABuilt 2017 · S/N 2348 N1241GCastanon Mike · Perryton, TXBuilt 2007 · S/N 41777 N1242HKaliebe Kyle D · Mount Pleasant, WIS/N 28-7790297 N1243HGordon Stephen · Warrington, PABuilt 1976 · S/N 28-7790298 N1243XAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 41755 N1244TMiddle Tennessee State University · Murfreesboro, TNBuilt 2015 · S/N 40.1191 N1249CDane Aviators LLC · Waunakee, WIBuilt 2003 · S/N 1268 N124CRAero-Mobil Inc · Wilmington, DES/N 2003 N124ECSpry Logistics LLC · Ponchatoula, LABuilt 2006 · S/N 1995 N124EDSecond Wind Enterprises LLC · Chamblee, GABuilt 2014 · S/N 4636642 N124JDBailes Christopher · Orlando, FLBuilt 1999 · S/N 2843239

Back to AD 2008-06-28 R1