Registered aircraft · 16,290

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.

N107AJAltitude Aviation LLC · West Point, GABuilt 2007 · S/N 2671 N107BCCjw Aviation LLC · San Antonio, TXS/N 3057 N107CBR&Dsl Corp Trustee · Wilmington, DEBuilt 2008 · S/N 3244 N107CDKhalil Hassan · Clarks Summit, PABuilt 2000 · S/N 1018 N107KCRandall Frederick Kuchenmeister · New Baltimore, MIBuilt 2011 · S/N 40.1126 N107MCVeratix Ventures LLC · Carlsbad, CABuilt 2013 · S/N 4636609 N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107MTTuch Michael · Gonzales, TXS/N 4846 N107MUMarshall University · Huntington, WVBuilt 2021 · S/N 2784 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N107PBAntler Air LLC · Klamath Falls, ORBuilt 2006 · S/N 2292 N107TQSouthland Air Holdings LLC · Albany, GABuilt 2013 · S/N 3996 N107UVUtah Valley University · Orem, UTBuilt 2009 · S/N 40.1030 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462 N1087GBulzan Gary · Chardon, OHBuilt 1996 · S/N 4636150 N1087TCampagna Thomas B · Midland, TXBuilt 2008 · S/N 411033 N1088DSpf America LLC · Fort Smith, ARBuilt 2009 · S/N 421015 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N108CFCentral Flying Service LLC · Little Rock, ARBuilt 2005 · S/N 40.479 N108EZGraybull Aviation LLC · Lake Orion, MIBuilt 2006 · S/N 2037 N108GPCoral Desert LLC · Andalusia, ALBuilt 2005 · S/N 1317 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997 N108KKSafety First LLC · Missoula, MTBuilt 2010 · S/N 4697424 N108MGSr20 Holdings LLC · Coral Springs, FLBuilt 2023 · S/N 9431 N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328 N108UVUtah Valley University · Orem, UTBuilt 2003 · S/N 40.342 N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116 N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251 N1097LInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 2008 · S/N 421006 N1098RSweat Kristie S · Buford, GABuilt 2021 · S/N 5010 N109FTCisco Aero LLC · Cisco, TXBuilt 2006 · S/N 2025 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N109MPCirrus Design Corp · Duluth, MNS/N 11905 N109UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1214 N109WKEast Bay Trading Co · Fairview, PABuilt 2004 · S/N 1400 N10BXCleary James A · Fairfield Township, OHBuilt 2021 · S/N 5003 N10DKVillage Air LLC · Wichita, KSBuilt 1999 · S/N 4636223 N10DLMoul Daniel P · Hanover, PABuilt 2008 · S/N 4692073 N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044 N10MCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1084 N10RAOne Six Bravo LLC · Kernersville, NCBuilt 2021 · S/N 5069 N10STGocc Blue Sky LLC · Augusta, GABuilt 2005 · S/N 4697220 N10UWHorton Raymond Trustee · Phoenix, AZBuilt 2025 · S/N 11054 N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310 N10XJNext Phase Ia LLC · Las Vegas, NVS/N LW-117 N10ZWBurnett Wade C · Sandpoint, IDBuilt 2001 · S/N 0055 N1108TSale Reported · Crystal, MNSale reportedBuilt 2011 · S/N 2114 N110BMDrewcy Inc · Wilmington, DEBuilt 1978 · S/N LW-273

Back to AD 2008-06-28 R1