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.

N612DAAero Eleven LLC · Winter Garden, FLBuilt 2007 · S/N 1849 N612EZCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 4734 N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197 N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195 N612JMPerformance Aviation LLC · Zionsville, INBuilt 2010 · S/N 3692 N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518 N612PBFord Alan · Dallas, TXS/N 3156 N612SBGronemeyer Jens · Deland, FLBuilt 2004 · S/N 41013 N612SLN612sl Skynance LLC · Marshfield, WIBuilt 2024 · S/N 4636842 N612WInhoc Capital Holdings LLC · Dallas, TXBuilt 2024 · S/N 10008 N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655 N612XCSkiventure Holdings LLC · Wayzata, MNBuilt 2013 · S/N 4023 N6133PEastwood LLC · Pikeville, KYBuilt 2003 · S/N 0639 N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757 N613BZAsi Equipment LLC · Forsyth, MOBuilt 2022 · S/N 8688 N613CMcb Consultants LLC · Camden, DEBuilt 2026 · S/N 11436 N613DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1851 N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091 N613ELJamber Aviation LLC · De Pere, WIBuilt 2025 · S/N 10666 N613JMAngel One Aviation LLC · Pittsburgh, PABuilt 2006 · S/N 41583 N613MKFlatlands Aviation LLC · Brooklyn, NYBuilt 2016 · S/N 4400 N613MMCome Fly With US LLC · Purcellville, VABuilt 2005 · S/N 1497 N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034 N613WTouch And Go Aviation LLC · Peoria, AZBuilt 2016 · S/N 2326 N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229 N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230 N614BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881856 N614CTailwinds LLC · Warsaw, INBuilt 2002 · S/N 0411 N614CFBro Air LLC · Columbus, OHBuilt 2024 · S/N 9876 N614CY614 Charlie Yankee Lc · Ames, IABuilt 2004 · S/N 1050 N614DPInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 447995119 N614DSBcd Leasing Corp · Lexington, KYBuilt 2005 · S/N 40.601 N614EATop Joint LLC · Huntingburg, INBuilt 2023 · S/N 9591 N614PAPafford Holdings LLC · Ridgeland, MSS/N 1981 N614RCMacisaac Richard · Northampton, MABuilt 2002 · S/N 0249 N614RZRasmusson Timothy · Elma, NYBuilt 2004 · S/N 0897 N614SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881623 N614SRForest Restoration Inc · Philomath, ORBuilt 2006 · S/N 2166 N614STMedi-Tek Inc · Antioch, CABuilt 2014 · S/N 4636614 N6150JCypress Aviation LLC · Malvern, PAS/N 28-7690353 N6151HFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7890211 N6154HTravis Air Force Base Aero Club · Travis Afb, CABuilt 1977 · S/N 28-7890212 N6154WBramlett LLC · Carrollton, TXBuilt 2003 · S/N 0632 N615BBBmu22 LLC · Lancaster, OHBuilt 2005 · S/N 1682 N615CMA Cirrus Life LLC · Santa Barbara, CABuilt 2006 · S/N 2010 N615DATrident Aircraft Leasing LLC · Easton, MDBuilt 2007 · S/N 1853 N615DCSheeree Corp · Wilmington, DES/N 28-7716178 N615DVLunada Bay Dental Practice Dyan Van De Velde Dmd · Pls Vrds Est, CABuilt 2005 · S/N 40.470 N615EMGinther Associates LLC · Hillsdale, NYBuilt 2010 · S/N 3682 N615FTFlorida Institute Of Technology · Melbourne, FLBuilt 1980 · S/N 28-8116123

Back to AD 2008-06-28 R1