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.

N1970PWootton Donald W · Houston, TXBuilt 1981 · S/N 32R-8129044 N1972MN1000 LLC · St Simons Island, GABuilt 2014 · S/N 4636631 N1972XAds Investment Firm LLC · Pacifica, CABuilt 2012 · S/N 4636524 N1973HAllen Quandt Inc · Grand Island, NES/N 28-7716073 N1974BDeltahawk Engines Inc · Racine, WIBuilt 2002 · S/N 1233 N1978HHarow Peter M · Forked River, NJBuilt 1977 · S/N 28-7790364 N1978RJ Martin Auctions LLC · Waterloo, NYBuilt 2023 · S/N 9327 N1978WFlytighe LLC · Winchendon, MABuilt 2021 · S/N 5009 N197CPN197cp LLC · Columbus, GABuilt 2008 · S/N 3056 N197DJN197dj LLC · Palm Harbor, FLBuilt 1997 · S/N 32-46074 N197DSHanover LLC · London, KYBuilt 2005 · S/N 40.586 N197LABg Family Limited Partnership · Edinburg, TXBuilt 1997 · S/N 4636098 N197MAShore Air LLC · Trappe, MDBuilt 1997 · S/N 4636079 N197PMRegistered aircraftBuilt 1997 · S/N 4636086 N197SRLakeside Roofing And Construction LLC · Yukon, OKBuilt 2007 · S/N 2547 N1984MAnacapa Aviation LLC · Oxnard, CABuilt 2015 · S/N 4218 N1987MPace Air LLC · Odessa, TXBuilt 2025 · S/N 4636872 N198CMOff Rock Aviation LLC · Lewes, DEBuilt 1981 · S/N 34-8133250 N198FTOrtiz Santiago Gil · Miami, FLBuilt 1982 · S/N 28-8216198 N198JCLong Bayou LLC · Vero Beach, FLBuilt 1998 · S/N 3257028 N198PSDorsing Kevin G · Othello, WABuilt 1998 · S/N 3449051 N198SRCross Creek Aviation LLC · Bossier City, LABuilt 2007 · S/N 2679 N198SWFerguson Robert S · Riverview, FLBuilt 1977 · S/N 28-7890130 N198TCSky Ryder Aviation LLC · Lewisville, TXBuilt 1998 · S/N 3257047 N198WCy Properties Inc · Durango, COBuilt 1997 · S/N 3257012 N1992HBradley Aircraft Company LLC · Columbus, INBuilt 1977 · S/N 28-7716076 N1993HSmith Brian S · Spring, TXS/N 28-7790367 N1995HFogarty Jayne I · Hartford, SDBuilt 1977 · S/N 28-7790369 N1997Church Aviation LLC · Christmas Valley, ORBuilt 2007 · S/N 41795 N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283 N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956 N199CPKbl Cvx LLC · Bellaire, MIBuilt 2001 · S/N 4697099 N199DBWingo Inc · Fort Myers, FLS/N 9994 N199DWAeon62 Holdings LLC · Plano, TXBuilt 1980 · S/N LW-338 N199GKNovember Alpha LLC · Los Angeles, CABuilt 2007 · S/N 2644 N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268 N199HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 3246126 N199PCPhoenix Capital Holdings LLC · Ocala, FLBuilt 2024 · S/N 10277 N199PLDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-167 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N199USKleiman David Joseph · Valley Center, CABuilt 2024 · S/N 9944 N19AVGhafouri Mohsen · Murrieta, CABuilt 1981 · S/N 28-8216106 N19CTK&K I LLC · Los Angeles, CABuilt 2018 · S/N 4642 N19CXSingle Windmill Ranch LLC · Austin, TXBuilt 2001 · S/N 4697077 N19JMTlc Car Wash Land Trust Corp · Homosassa, FLS/N 3382 N19JPSheldon Law Pllc · Scottsdale, AZBuilt 1997 · S/N 4636119 N19PMFlying Turtle LLC · Carmel, INBuilt 2022 · S/N 9027 N19QTInternational Aviation Group LLC · Lake Wales, FLBuilt 2003 · S/N 0593 N19RMRmaction Inc · Stevenson Ranch, CABuilt 2007 · S/N 2631 N19SERegistered aircraftBuilt 1968 · S/N 28R-30525

Back to AD 2008-06-28 R1