Registered aircraft · 16,284

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.

N987TMRgm Aviation LLC · Brentwood, TNBuilt 2009 · S/N 3531 N987WEstrada Alfonso · Santa Teresa, NMBuilt 2004 · S/N 1062 N987WTRangerair LLC · Melbourne, FLBuilt 2006 · S/N 2125 N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192 N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205 N988AMM & G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 2881579 N988CDKading Kevin · Tucson, AZBuilt 2004 · S/N 0889 N988GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881493 N988JFMcdaniel Patrick D · State College, PABuilt 1999 · S/N 2843287 N988JLL 3 Air LLC · Weston, WIBuilt 2010 · S/N 3639 N988LLGozaimas Aviation LLC · Miami Beach, FLBuilt 2012 · S/N 2161 N988NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 4496592 N988PZeve Bradley · Carmel, CABuilt 2005 · S/N 41094 N988SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2038 N989AVFlying Rj LLC · North Caldwell, NJBuilt 2021 · S/N 4636790 N989BDGlacier Aircraft 3 LLC · Orlando, FLBuilt 2024 · S/N 9902 N989BEPerformance Air LLC · Hobbs, NMBuilt 2022 · S/N 8907 N989CAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 2445 N989DFKearns Floyd M · Houston, TXBuilt 2003 · S/N 0554 N989ECHagan Aaron Kirk · Park City, UTBuilt 2008 · S/N 3099 N989FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496651 N989HKTailwinds Aviation LLC · New Orleans, LABuilt 2019 · S/N 4859 N989MAButler Holdings · Franklin, TNS/N 40.389 N989MBBhasin Monica · Holtsville, NYBuilt 2026 · S/N 11462 N989PSReliable Property Solutions LLC · Stockbridge, GABuilt 2014 · S/N 4104 N989SBConquest Shares LLC · Liberal, KSBuilt 1979 · S/N 441-0089 N989SRBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 3257268 N98BKThomas W Wilkinson Cpa Pllc · Austin, TXS/N 3527 N98DBDb Aero Restoration LLC · Wilmington, OHBuilt 1977 · S/N 28-7790474 N98HFValiair Ltd Co Trustee · Casper, WYBuilt 1973 · S/N LW-89 N98HHLittle Wing LLC · Block Island, RIBuilt 2006 · S/N 2260 N98HSSaunders Robert A · Barrington, RIBuilt 1997 · S/N 2843086 N98JFYls Aviation LLC · Bozeman, MTBuilt 2001 · S/N 3257247 N98KCBelles Aviation LLC · Missoula, MTBuilt 1976 · S/N BB172 N98LAEwa LLC · Redding, CABuilt 1998 · S/N 3257031 N98LWConstruction Equipment Manufacturing Co Inc · Olney, TXBuilt 2009 · S/N 3428 N98MVFargo Jet Center LLC · Fargo, NDBuilt 1995 · S/N 28-90216 N98PFDakota Acre Farms Inc · Denhoff, NDBuilt 1985 · S/N 28-8516044 N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131 N98RADenaina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB439 N98RFDabosa LLC · Bernville, PABuilt 2003 · S/N 0520 N98SLKm Ventures LLC · Waltham, MABuilt 2019 · S/N 4868 N98TLAir Dynamics LLC · West Des Moines, IABuilt 1998 · S/N 3257061 N98UTM&P Investment Partners LLC · Eastsound, WABuilt 2008 · S/N 411051 N98VGBarron 301p LLC · Olive Branch, MSBuilt 1977 · S/N BB-252 N98VSHarrison Aero Ventures LLC · Suwanee, GABuilt 2025 · S/N 10953 N98WLN7876p LLC · Monument, COBuilt 1998 · S/N 3257051 N98ZZF4 Holdings LLC · Oro Valley, AZBuilt 2024 · S/N 4636853 N9900KLong Jimmie Brian · Cropwell, ALBuilt 2005 · S/N 2843617 N9908KG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7890198

Back to AD 2008-06-28 R1