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.

N343RJDownhour Aviation II LLC · Benton, LABuilt 2022 · S/N 8643 N343RRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 4697197 N343SArrow 180 LLC · Reno, NVBuilt 1969 · S/N 28R-31118 N343SGGustafson Scott Lyle · Greenwood Village, COBuilt 2009 · S/N 40.1064 N343STJagc LLC · Freeport, FLBuilt 2015 · S/N 4264 N343TAUS Air Force · Rio Vista, CABuilt 2006 · S/N 2843646 N343TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881551 N3442TBoyle Ventures LLC · Rogers, ARBuilt 2010 · S/N 3710 N3443MBurner Dwight L · Mc Gaheysville, VABuilt 1977 · S/N 28-7890302 N344ARpm Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2888 N344AFUtah State University · Logan, UTBuilt 2009 · S/N 40.1044 N344BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 4496582 N344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0156 N344DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843832 N344DD563bt LLC · Fripp Island, SCBuilt 2019 · S/N 2504 N344DGAircraft Solutions LLC · Spokane, WABuilt 2017 · S/N 2362 N344DSStar Of Africa Capital LLC · Villanova, PABuilt 2008 · S/N 40.1026 N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344 N344SKDriver Aviation LLC · Bloomfield Hills, MIBuilt 2007 · S/N 2657 N344TAJcg-Air LLC · Valdosta, GABuilt 2006 · S/N 3255048 N344WASorensen Air LLC · Syracuse, UTBuilt 2024 · S/N 4636844 N3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeS/N 28-7716156 N3459Q51st Aero Squadron LLC · Hoover, ALS/N 28-7790458 N345AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881812 N345CERich Leasing · Edmond, OKS/N 1352 N345DAGrigg Apiaries Inc · Hot Springs, MTBuilt 2005 · S/N 1674 N345EFVenbro Holdings LLC · Brooklyn, NYBuilt 2021 · S/N 2731 N345ETKeene Warren · Post Falls, IDBuilt 2003 · S/N 0492 N345FAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1979 · S/N 44-7995326 N345HBWomack Mark G · Chico, CABuilt 2008 · S/N 421011 N345JREastern Stearman Inc Trustee · Leesburg, VABuilt 2003 · S/N 0594 N345MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881262 N345MMMarciaran LLC · Dover, DEBuilt 1990 · S/N 4622112 N345RPMcdole Consulting LLC · Southern Shores, NCBuilt 1990 · S/N 4622096 N345SEPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 3257345 N345TSUncle Bob Consulting LLC · Antioch, ILBuilt 2005 · S/N 1569 N345WTRegistration Pending · North Wilkesboro, NCRegistration pendingBuilt 2006 · S/N 4697267 N345WZEntroair LLC · Hilliard, OHBuilt 2021 · S/N 5028 N345YParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020123 N346DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843833 N346DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 40.1066 N346JVPjm Equipment Lp · Jordan, MNBuilt 2011 · S/N 4697477 N346MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881416 N346TMDierking Jason Michael · Storm Lake, IABuilt 1996 · S/N 4636046 N346TXKurk Mcginley Enterprises Inc · The Woodlands, TXBuilt 2013 · S/N 4692200 N3471MParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816346 N3474MSolverson Britt B · Hazel Green, WIBuilt 1978 · S/N 28-7890303 N3477MCapella LLC · Parkville, MOBuilt 1978 · S/N 28-7890305 N347BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881652 N347CASouth Bay Air LLC · Romulus, MIS/N 411004

Back to AD 2008-06-28 R1