Registered aircraft · 16,280

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.

N7638JSeward Charles Ryan · Nashville, INBuilt 1968 · S/N 28R-31037 N7639JCampbell Ronald David · Etna, WYBuilt 1968 · S/N 28R-31038 N763CPlane Partners LLC · Greensboro, NCBuilt 2002 · S/N 0431 N763CAAttar Aviation LLC · West Hills, CABuilt 2014 · S/N 2251 N763CDFlyingmalbec LLC · Lakeway, TXBuilt 2005 · S/N 1689 N763DYSgl Aviation LLC · Fairfield, NJBuilt 2006 · S/N 1753 N763LSJaybird Aviation LLC · Many, LABuilt 2009 · S/N 3487 N763TAAbne Flight LLC · Brookshire, TXBuilt 2025 · S/N 10547 N7640UOhio University · Albany, OHBuilt 2025 · S/N 10561 N7641JFrazier Michael K · Abbeville, GABuilt 1968 · S/N 28R-31041 N7642JUniversal Technical Institute Inc · Coppell, TXBuilt 1968 · S/N 28R-31042 N7644FBel Holdings LLC · Albert Lea, MNBuilt 1976 · S/N 28-7790201 N7645FSagittarius Fox Aviation LLC · San Francisco, CABuilt 1976 · S/N 28-7790202 N7645JArrow 8 LLC · Chicago, ILBuilt 1969 · S/N 28R-31045 N7646FShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 28-7790204 N7646JRavotti Air LLC · Leechburg, PABuilt 1968 · S/N 28R-31046 N764CCYale Companies LLC DBA Hot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 2881918 N764DSDavis Rod A · Washington, UTBuilt 2007 · S/N 40.764 N764NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843894 N764TAT Squared Aviation LLC · Brookshire, TXBuilt 2025 · S/N 10601 N764WAAlcyone Trust Corp Trustee · Wichita, KSBuilt 2020 · S/N 4636764 N7650JAmsg Transport LLC · Southfield, MIS/N 28R-31050 N7650UOhio University · Albany, OHBuilt 2025 · S/N 10566 N7652JCamilo Rafael Gonzalez Moya · Fort Worth, TXS/N 28R-31052 N7653FHyldburg Aviation Inc · Plymouth, MABuilt 1976 · S/N 28-7790205 N7653JGulley Peter M · Karnes City, TXBuilt 1969 · S/N 28R-31053 N7654JGarrison Trading LLC · Prescott, AZBuilt 1969 · S/N 28R-31054 N7654TD Scott Smith Dvm Pa · Mountain Home, ARBuilt 2000 · S/N 1019 N7656JBurton David N · Pittsgrove, NJBuilt 1968 · S/N 28R-31056 N7658JGarner Kenneth W · Decatur, ALBuilt 1969 · S/N 28R-31058 N7659JEdwards Robert B Jr · Macon, GABuilt 1968 · S/N 28R-31059 N765CTBim Jett LLC · Sacramento, CABuilt 2008 · S/N 3216 N765GMFacts Holdings Inc · Clearwater, FLS/N 4004 N765NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843895 N765SMHarrison Edward G · San Francisco, CABuilt 2008 · S/N 411114 N765WAValiair Lc Trustee · Casper, WYBuilt 1980 · S/N BB-765 N7660UOhio University · Albany, OHBuilt 2025 · S/N 10567 N7661JMitchell Edson · El Dorado Hills, CABuilt 1970 · S/N 28R-31061 N7662JBurns Christopher Jason Gary · Natrona Heights, PABuilt 1969 · S/N 28R-31062 N7663FBandstra James R · Big Rapids, MIBuilt 1976 · S/N 28-7790209 N7664FSkyfusion II LLC · Atlanta, GABuilt 1976 · S/N 28-7790210 N7664JTrue Arrow Aviation LLC · Cloverdale, CABuilt 1970 · S/N 28R-31063 N7666JCavallaro Jack C · Jordan, NYBuilt 1968 · S/N 28R-31065 N7667CDoral Aviation LLC · Jefferson Hills, PABuilt 1975 · S/N 28-7690074 N766AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496245 N766ATAdvisoar LLC · Jacksonville, FLBuilt 2011 · S/N 3766 N766GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881463 N766LAN766la LLC · Philadelphia, PABuilt 2025 · S/N 28020218 N766NDGfk Wings LLC · Grand Forks, NDBuilt 2017 · S/N 2843896 N766SAN766sa LLC · Sheridan, WYBuilt 2000 · S/N 1101

Back to AD 2008-06-28 R1