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.

N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N10502Flying Chipmunk LLC · Charlotte, NCBuilt 2025 · S/N 10502 N10580Dwyer Lawrence William · Berthoud, COS/N 411150 N10582Horizon A Dream Inc Trustee · Wilmington, DES/N 411152 N10586Cloud #9 Enterprises Inc · Mooresburg, TNS/N 4636404 N1058ZBaillie Richard Leslie · Newark, DEBuilt 2008 · S/N 411058 N1059FRandag William F Jr · El Paso, TXS/N 2843643 N105AVAbbey Air Corp · New Castle, PABuilt 1983 · S/N 28-8490012 N105CKHdm Aviation LLC · Saratoga, CABuilt 2016 · S/N 4399 N105DGFraser And Daughter LLC · Saint Augustine, FLBuilt 2024 · S/N 4636857 N105DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881910 N105HCJi Aviation LLC · Vidalia, LABuilt 2019 · S/N 4777 N105HPRyan Transportation Services Ltd · Marysville, OHBuilt 2003 · S/N 3257322 N105HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881996 N105KLWing It LLC · Madison, WIBuilt 2017 · S/N 4461 N105MUMarshall University · Huntington, WVBuilt 2020 · S/N 2625 N105TTW&P Aircraft LLC · Humble, TXBuilt 2006 · S/N 1867 N105UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.685 N105WLSchmitt Family Holdings LLC · Independence, IABuilt 2006 · S/N 2210 N1061TPlumbers Air Supply LLC · Overland Park, KSBuilt 2006 · S/N 4697274 N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440 N1063LWjm Aviation LLC · North Wales, PABuilt 2006 · S/N 2843644 N1064SSterling Smkr3 LLC · Oklahoma City, OKBuilt 2007 · S/N 4636411 N1065DN1065d Mirage LLC · Rockville, MDBuilt 2006 · S/N 4636401 N1065YKerin Charles A Dvm · Wylie, TXS/N 4697295 N1066BWexhler David R Trustee · Carlsbad, CABuilt 2006 · S/N 3257443 N1066ERising Skies LLC · Carefree, AZBuilt 2006 · S/N 3246244 N1066SOmll Investments LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 3257457 N10691Reed Kerr Aviation Inc · Wilmington, DEBuilt 1984 · S/N 34-8433050 N10694H&A Aviation LLC · Anniston, ALBuilt 2007 · S/N 4697297 N106BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843582 N106CDAerou LLC · Oviedo, FLBuilt 2000 · S/N 1015 N106DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881911 N106EMVenture West LLC · Mesa, AZBuilt 1977 · S/N 28-7790460 N106EZDannemann Kevin · Wallkill, NYBuilt 2006 · S/N 2044 N106FMGroner Michael F · Hicksville, NYBuilt 1978 · S/N 28-7990199 N106HPAgain2 · San Diego, CABuilt 2003 · S/N 2843560 N106LValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 3257130 N106LUBluewater Plumbing Service LLC · Wilmington, NCBuilt 2005 · S/N 1501 N106MUMarshall University · Huntington, WVBuilt 2021 · S/N 2682 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N106TJN106tj LLC · Murray, UTBuilt 2010 · S/N 3592 N106TQRogers Scott · Asheville, NCBuilt 2007 · S/N 2633 N106UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.686 N1071CBmk Aviation LLC · Northampton, PABuilt 2006 · S/N 2843648 N1071SEla Group Inc · Shreveport, LAS/N 4697298 N1075NBlackstone Barry V · Superior, NEBuilt 2007 · S/N 4636421 N1075RGeorgia Aviation Authority · Eastman, GABuilt 2006 · S/N 2843649 N10767Kansa Development Corporation Inc · Junction City, KSBuilt 2007 · S/N 4636409 N1076QExecutive Flight Institute LLC · Murrieta, CABuilt 1977 · S/N 28-7790374

Back to AD 2008-06-28 R1