Skip to content

Registered aircraft · 22,416

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N8724EDcs School Of Flying LLC · York, PABuilt 1976 · S/N 28-7615152 N8724NSea 2 Sea LLC · Cantonment, FLBuilt 1969 · S/N 28-25537 N8724WFrench Loren C · Gypsum, COS/N 28-10259 N8725ERrr Transportation LLC · Oneonta, ALFirst renewal noticeBuilt 1976 · S/N 28-7615153 N87269Clint Aaron Aviation LLC · Columbus, GABuilt 1976 · S/N 287725067 N8727FVancura Aviation LLC · Seffner, FLBuilt 1976 · S/N 28-7725124 N8727NMelder Brandon W · Alexandria, LABuilt 1969 · S/N 28-25540 N8727WEwing Cori · Boulder, COBuilt 1966 · S/N 28-10799 N8729NCano Felix H · Fort Worth, TXBuilt 1969 · S/N 28-25544 N872AMBecker Thomas Lee · Arlington, VABuilt 1978 · S/N 28-7890333 N872MAFalligant Robert E · Savannah, GABuilt 1968 · S/N 28-24611 N872WAMorin Vincent A · El Segundo, CABuilt 1977 · S/N 28R-7703182 N872WLKryzsko Joshua Don · Livingston, MTBuilt 1971 · S/N 28R-7135123 N8730WMoore Claire · El Prado, NMBuilt 1964 · S/N 28-10265 N8731EFournier Charles J · Redding, CABuilt 1976 · S/N 28-7615154 N8732CDiluzio Brad M · Graham, WABuilt 1976 · S/N 28R-7635179 N8732WAllison Daryl · Lubbock, TXBuilt 1964 · S/N 28-10267 N8733EHoward Allan C · New Preston, CTBuilt 1976 · S/N 28R-7635207 N8734EKrukowski Edward A · Miami, FLBuilt 1976 · S/N 28R-7635208 N8734NLowe Brian D · Prescott, KSBuilt 1969 · S/N 28-25549 N8734WLumberjack Holdings LLC · Kalispell, MTBuilt 1964 · S/N 28-10274 N8735EKleiss James · Pesotum, ILBuilt 1976 · S/N 32R7680169 N8735NManzanares Jason J · Albuquerque, NMBuilt 1969 · S/N 28-25550 N8735WJohnson Everett C · Las Cruces, NMBuilt 1964 · S/N 28-10275 N8737ECarleton Scott A · Van Nuys, CABuilt 1976 · S/N 28-7625152 N8737NWatkins Michael · Oak Harbor, WABuilt 1969 · S/N 28-25553 N8737WLaugharn Mitchell · San Jose, CABuilt 1964 · S/N 28-10277 N8738NCf & Cb Inc · Atlantic Beach, FLBuilt 1969 · S/N 28-25356 N8738WRempel Leon Plett · Prague, OKS/N 28-10801 N8739CBright Apps LLC · Walnut Creek, CABuilt 1976 · S/N 28-7610079 N8739ERobinson Wilbert J Jr · Stockton, CAS/N 28-7615157 N8739WMansour Muhamad A · Wichita, KSS/N 28-10279 N873ARRincon Jose Antonio · Santa Maria, CABuilt 1966 · S/N 32-817 N873PAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2020 · S/N 2881338 N8740NNorth Vanessa C · San Luis Obispo, CABuilt 1969 · S/N 28-25555 N8741EWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 28-7690196 N8741NBarber Jeffrey B Trustee · Sparks, NVBuilt 1969 · S/N 28-25556 N8741WClardy E Dennis · Mountain View, ARBuilt 1964 · S/N 28-10281 N8742ERegistration Pending · Riverside, MORegistration pendingBuilt 1976 · S/N 32R-7680170 N8743EKopitzke Christopher · Lexington, KYBuilt 1976 · S/N 32R-7680171 N8743NRegistered aircraftBuilt 1969 · S/N 28-25559 N8744NTsuei Mark · San Mateo, CAFirst renewal noticeBuilt 1969 · S/N 28-25558 N8745FGawer Randy · Beaverton, ORBuilt 1976 · S/N 28-7715288 N8745WLeedahl Aircraft LLC · Leonard, NDBuilt 1964 · S/N 28-10285 N8746NByard Jeffery G · Carson City, NVBuilt 1969 · S/N 28-25562 N8747EBarbrie Nicholas J · Pittston, PABuilt 1976 · S/N 28-7625153 N8747WAncient Waters Entertainment · Torrance, CABuilt 1964 · S/N 28-10287 N8749ESheboygan Flight Plane I LLC · Sheboygan, WIBuilt 1976 · S/N 28-7615158 N8749NPowell Randell W · Wachapreague, VABuilt 1969 · S/N 28-25569 N8749WWooten Anthony P · Waxahachie, TXBuilt 1964 · S/N 28-10289

Back to AD 87-08-08 R3