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.

N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186 N53JSC-140 Company LLC · Milton, FLBuilt 1968 · S/N 28R-30840 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N53KBHiers Properties Of Delaware LLC · Chattanooga, TNBuilt 2005 · S/N 4697231 N53KCDm Asset Management LLC · Plain City, OHBuilt 1978 · S/N 28-7990032 N53PBAtlas Aerospace Capital LLC · Lewes, DEBuilt 2006 · S/N 1684 N53PKSpantech LLC · Glasgow, KYS/N 4697093 N53SHJames Robinson Homes LLC · Alpharetta, GABuilt 2021 · S/N 5008 N53SLFly For Fun Aircraft LLC · Rockville, MDBuilt 2005 · S/N 40.519 N53WPRaich Aerospace Group LLC · Ormond Beach, FLBuilt 2004 · S/N 1435 N5407FFly Quest Aviation LLC · La Verne, CABuilt 1977 · S/N 28-7790112 N5409FBlackwolfden Aviation LLC · Belgrade, MTS/N 28-7790114 N540CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881049 N540PGSea Level Aviation LLC · Mount Pleasant, SCBuilt 2008 · S/N 1998 N540UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020164 N540WBAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 2002 · S/N 3257269 N54105Gopub Aviation Inc Trustee · Wilmington, DEBuilt 2004 · S/N 1139 N5411JTdm Aviation LLC · Huntsville, ALBuilt 1980 · S/N 441-0192 N54175Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1337 N54199Key Aviation Group LLC · Meridian, MSBuilt 2003 · S/N 4697164 N5419FJfl Aviation LLC · Big Rock, ILBuilt 1976 · S/N 28-7790117 N5419WKenosha Aviation LLC · Jacksonville, FLS/N 0857 N541AJRadiant Flight LLC · Roanoke, VAS/N 40.541 N541BPEdge Aircraft LLC · Denver, COBuilt 1999 · S/N 3257087 N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089 N541CDAcheson Wiliam B · Waconia, MNBuilt 2005 · S/N 1491 N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050 N541DFSr20 Holdings LLC · Coral Springs, FLBuilt 2025 · S/N 10869 N541DSScrappy Air LLC · Satellite Beach, FLBuilt 2007 · S/N 40.797 N541JDBlue Sky Flyers LLC · Hoover, ALBuilt 2002 · S/N 0315 N541NDBig Sky Flight LLC · Helena, MTBuilt 2008 · S/N 4697356 N541SRSierom LLC · Charlotte, NCS/N 2109 N541VAColumbia Associates LLC · Potomac Falls, VAS/N 41608 N541VBCartier John · Cumberland, RIBuilt 2003 · S/N 3257334 N541WPStorzer Daniel Norman · Neenah, WIS/N 1931 N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118 N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119 N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762 N542AMSolid Rock Stone Inc · Shady Point, OKBuilt 2007 · S/N 2666 N542BP777 Air LLC · Bowling Green, KYBuilt 2006 · S/N 41674 N542CDStorch David · Goodyear, AZBuilt 2004 · S/N 1186 N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051 N542GLWurfel David G · Trinidad, COBuilt 2012 · S/N 40.1141 N542JJAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 4496542 N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772 N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866 N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364 N542PFKittyhog Air LLC · Margate, FLBuilt 2008 · S/N 3144 N542PGMountain Airplane LLC · Alpine, WYBuilt 2008 · S/N 3002 N542SFNoble Aviators LLC · Myrtle Beach, SCBuilt 2017 · S/N 4439

Back to AD 2008-06-28 R1