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.

N329TTJsh Aviation LLC · Dover, DEBuilt 2011 · S/N 4636513 N329WMMorning Star Aviation Services LLC · Charleston, SCS/N 3868 N32AJFreedom Plane LLC · Freedom, NHBuilt 2012 · S/N 3852 N32AZChristian Brothers Aviation LLC · Dalton, GABuilt 2013 · S/N 4028 N32CARegistration Pending · Fairbury, NERegistration pendingBuilt 2005 · S/N 4697216 N32CDN32cd Aviation Services LLC · Aptos, CABuilt 2005 · S/N 1521 N32CKN32ck Corp Trustee · Wilmington, DEBuilt 2001 · S/N 4697123 N32CZElk Mountain Rentals Inc · Waynesville, NCBuilt 2003 · S/N 3255011 N32EFMellett Aviation LLC · Point Pleasant, NJBuilt 2024 · S/N 10322 N32EJFox Jason Ross · Buckley, WABuilt 1967 · S/N 28R-30287 N32EPCaravelle Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10801 N32FWMontgomery Aviation LLC DBA · Zionsville, INBuilt 2019 · S/N 2483 N32GRAngella Tony · Fort Lauderdale, FLBuilt 2001 · S/N 0046 N32JGBlackbird Florida LLC · Deerfield Beach, FLBuilt 2023 · S/N 9477 N32KHN32kh LLC · Quincy, WAS/N 287790384 N32MFHistick Logistics LLC · Camden, DEBuilt 2017 · S/N 4437 N32MGPoor Boy Aero LLC · Seminole, TXBuilt 1982 · S/N 32R-8329003 N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023 N32SJCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 2007 · S/N 3257473 N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199 N32SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2367 N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865 N32SXDorans Aviation LLC · Yardley, PABuilt 2004 · S/N 3232022 N32TCProprt LLC · Santa Monica, CABuilt 2009 · S/N 4697411 N32TEBlue Line Aviation LLC · Dunbar, NEBuilt 1999 · S/N 3257112 N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456 N32VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496430 N32WBFly Away LLC · Aguanga, CABuilt 2008 · S/N 3291 N32WFN32wf LLC · Muscatine, IAS/N 3246026 N330CDDec Enterprises LLC · Naples, FLBuilt 2005 · S/N 1319 N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330HCTf Op LLC · Houston, TXBuilt 2023 · S/N 9223 N330SUOklahoma State University · Stillwater, OKBuilt 2019 · S/N 2523 N330TFMartin Earl · Seneca Falls, NYBuilt 1996 · S/N 3246032 N3311GEdge Construction & Consulting Inc · Bement, ILBuilt 2007 · S/N 3257454 N331APSugar Creek Partners LLC · Rogers, ARBuilt 2021 · S/N 5109 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331EDDaniel Dunagan Inc · Rome, GABuilt 2017 · S/N 4544 N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277 N331JGLeone Richard · Edwards, MSS/N 1627 N331LMIslandflight Co · Wilmington, DEBuilt 1999 · S/N 3449137 N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477 N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514 N331SMApex Aviation LLC · Farmingdale, NYBuilt 2018 · S/N 4630 N331SWDos Perros Largos LLC · Prescott, AZBuilt 2026 · S/N 11298 N331TFCapital Holdings 244 LLC · Dover, DEBuilt 2024 · S/N 10133 N331TSAircraft Propulsion Leasing LLC · Holland, OHS/N 441-0264 N331WGRegistration Pending · York, PARegistration pendingBuilt 2026 · S/N 11509 N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296

Back to AD 2008-06-28 R1