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.

N858PUTrustees Of Purdue University · West Lafayette, INS/N 2881331 N858RCTurner Roger Dean · Rockwall, TXS/N 2939 N858SDPaulus Janene Trustee · Delaware, OHBuilt 2006 · S/N 1633 N858SMLoomer Donald W · Williston, NDBuilt 1982 · S/N 28-8290079 N858SRCharlie 25 LLC · Cedar Falls, IAS/N 32R-8329037 N858TDC J Flyin LLC · Salt Lake City, UTBuilt 2013 · S/N 4636601 N858TWNorthstar Air Fleet LLC · Mackinac Island, MIBuilt 2017 · S/N 4553 N8590ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020250 N8591CSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2026 · S/N 28020256 N8592ERegistration Pending · Vero Beach, FLRegistration pendingBuilt 2026 · S/N 28020257 N8593GPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020274 N8594FPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020275 N8595DPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020276 N859AZjb Aviation LLC · Harrisburg, PABuilt 2026 · S/N 11287 N859AVCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11551 N859BTBoyd Thornton Aviation LLC · Nicholasville, KYBuilt 2026 · S/N 11286 N859GAIsr Platforms LLC · Mclean, VABuilt 1980 · S/N BT-12 N859JFlying Aggies LLC · Louisville, KYBuilt 2006 · S/N 1996 N859JGLarocca Sandro · Yardley, PAS/N 42069 N859PABuelna Manuel Jr · Summerville, SCS/N 40.264 N859PUTrustees Of Purdue University · West Lafayette, INS/N 2881332 N859SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881742 N859SRMile High LLC · Bloomington, INBuilt 2007 · S/N 2835 N859WEMiller Elite Aviation LLC · Lexington, KYBuilt 2024 · S/N 9894 N85DAGp Aviation Services LLC · Wilmington, DEBuilt 2004 · S/N 1085 N85DJRegistered aircraftBuilt 1981 · S/N 32R-8129107 N85EABarley Aviation LLC · Sunset, SCBuilt 2008 · S/N 411050 N85NAHampden Aviation Services Inc · Northampton, MAS/N 287816296 N85SPBurkett Jacob E · Polk City, FLBuilt 1976 · S/N 28-7690216 N85TKStreamline Aviation LLC · Leawood, KSBuilt 2002 · S/N 4697128 N85UTFly Mwm LLC · Kemah, TXBuilt 1980 · S/N BB-678 N85WBRight Rudder LLC · Greenwich, CTBuilt 2006 · S/N 2294 N85WFTim Decker Aviation LLC · Franklin, TNBuilt 2005 · S/N 1384 N85YRGeneva Aviation LLC · Falmouth, MEBuilt 2013 · S/N 4697535 N860ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881385 N860FGCapital Holdings 299 LLC · Edwards, COBuilt 2025 · S/N 4636860 N860KSKansas State University · Salina, KSBuilt 2024 · S/N 4496572 N860PLunsford Group Inc · Winnsboro, SCBuilt 2001 · S/N 1149 N860PUTrustees Of Purdue University · West Lafayette, INS/N 2881333 N860SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881743 N860TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842417 N860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020195 N8611RGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-482 N8613AAeromedical Aviation LLC · Santa Maria, CABuilt 2005 · S/N 1344 N8619Cirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11590 N861DMAerolife Aviation LLC · Knox, INBuilt 2007 · S/N 1796 N861DPPoage Equipment LLC · Amarillo, TXBuilt 1996 · S/N 4636058 N861KSKansas State University · Salina, KSBuilt 2024 · S/N 4496573 N861MSSchlabach Sharon Kay · Myakka City, FLBuilt 2006 · S/N 1988 N861PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843945

Back to AD 2008-06-28 R1