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.

N9631CThompson Joseph D · Alliance, NEBuilt 1978 · S/N 28-7890431 N9638CJones Francis P Jr · Newport, ARBuilt 1978 · S/N 28-7816507 N9639CNichols Brian J · Mount Hope, WIBuilt 1978 · S/N 28-7816508 N963ABPiper Aircraft Inc · Vero Beach, FLS/N 28010090 N963CDBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 1470 N963DBCommonwealth Aircraft Inc · Ashland, VABuilt 2005 · S/N 1575 N963DMHaugen'S Hangar LLC · Williston, NDBuilt 2015 · S/N 4221 N963KAMeshoppen Air LLC · Tunkhannock, PABuilt 1977 · S/N LW242 N963LGValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10621 N963MADodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 4636453 N963NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881888 N963RBAmerican Fine Art Inc · Scottsdale, AZBuilt 2008 · S/N 2928 N963RTAppalachian Foothills Contracting Inc · Lexington, KYBuilt 2004 · S/N 1169 N963SBHoosier Oms LLC · Kalispell, MTBuilt 1999 · S/N 4636198 N963TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881963 N963WCCavorite Aviation LLC · Lehi, UTBuilt 2000 · S/N 2843381 N9642CBarts Flying Service Inc · Storm Lake, IABuilt 1978 · S/N 28-7816509 N964CDSolkshinitz Andrew · San Luis Obispo, CABuilt 2006 · S/N 1846 N964HRAnderson Ridge Holdings LLC · Lewes, DEBuilt 2021 · S/N 5088 N964LJAir Mercury LLC · New Rochelle, NYBuilt 1997 · S/N 3246082 N964SGWing Nuts Flying Club Ltd · North Chesterfield, VABuilt 2006 · S/N 42518 N964TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881964 N964WCStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843462 N9658KFlying Particles Inc · Livermore, CABuilt 1976 · S/N 28-7690271 N965ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841134 N965BJNorton Raquel D Trustee · Stateline, NVBuilt 2000 · S/N 3257140 N965GHHancock Aircraft Sales LLC · Baton Rouge, LAS/N 1666 N965JBKeevair LLC · Rockaway, NJBuilt 1997 · S/N 3246097 N965LGGoody Birds LLC · Prattville, ALBuilt 1976 · S/N LW-204 N965PWBeary Douglas Louis · Cary, NCBuilt 2017 · S/N 4546 N965SBFlynn Dog Aviation LLC · Port Charlotte, FLBuilt 2000 · S/N 4697015 N965TTFullbright Thomas D · Cold Spring, KYBuilt 2012 · S/N 4636560 N965XML Merlo LLC · Rockville, MDBuilt 2019 · S/N 4848 N9668CBrandywine Flight School Inc · West Chester, PABuilt 1978 · S/N 28-7816513 N9669CQuality Aero LLC · East Aurora, NYBuilt 1980 · S/N 28-8016361 N966AAGateway Of Sturgis LLC · Sturgis, MIBuilt 1978 · S/N 44-7995120 N966DAJoye Richard · Huntsville, ALBuilt 1996 · S/N 2843054 N966DSN966ds Inc Trustee · Wilmington, DEBuilt 2008 · S/N 40.1002 N966MGAirtrust LLC -6- Series 6 Trustee · Sheridan, WYBuilt 2008 · S/N 3155 N966NDUniveristy Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881924 N966RRegenski Paul · Bethany, PABuilt 1980 · S/N 32R-8013133 N966RKPacific Air Consulting LLC · Laguna Hills, CABuilt 2016 · S/N 2333 N966TTClemmer Rodney Duane · Roanoke, VABuilt 2006 · S/N 2051 N96706Cordingley Robert Lee · Lafayette, COBuilt 2001 · S/N 1116 N9671CFrench Loren · Gypsum, COS/N 28-7890435 N9674DSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 28-7816583 N9676KEjs Enterprises LLC · Incline Village, NVBuilt 1976 · S/N 28-7690272 N967ABPiper Aircraft Inc · Vero Beach, FLS/N 28010091 N967CMoran Transport LLC · Westminster, MABuilt 2002 · S/N 0417 N967DPAct2 Aviation LLC · Herndon, VABuilt 2003 · S/N 1287

Back to AD 2008-06-28 R1