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.

N7034RMacallen Chemical Inc · Monroe, LABuilt 1966 · S/N 28-21731 N7034WCooke Riley O · Bridger, MTBuilt 1962 · S/N 28-717 N7035JMiller James F · Hensley, ARS/N 28-7615349 N7035WJerome Jeffrey A · Conneaut Lake, PABuilt 1962 · S/N 28-718 N7036FLa Vigne Henry A · Hercules, CABuilt 1976 · S/N 28-7715192 N7036WArizona Flying Pigs LLC · Flagstaff, AZBuilt 1962 · S/N 28-719 N7037RJames Jerome A · Sioux Falls, SDBuilt 1966 · S/N 28-21734 N7038FFly With US LLC · Seminole, ALBuilt 1976 · S/N 28-7715193 N7038RElite Aircraft Services LLC · Pierce City, MOBuilt 1966 · S/N 28-21735 N7039CJdk Aviation LLC · Kalispell, MTBuilt 1975 · S/N 32-7640041 N703AMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2021 · S/N 28020018 N703CAFlying Penguin Aviation LLC · Atlanta, GAS/N 28-8116225 N703EADerrick Engineering Inc · Louisville, KYBuilt 1973 · S/N 28-7405036 N703FLRalls W A · Idabel, OKBuilt 1972 · S/N 28-7225255 N703GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881459 N703MAEverson Dustin J · Providence, RIBuilt 2001 · S/N 3246202 N703NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881021 N703PTFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881602 N703RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1977 · S/N 28-7716063 N703TKLorimar Group Inc · El Cajon, CABuilt 1968 · S/N 28-5165 N7040RDavies Lori M · Gainesville, TXS/N 28-21737 N7040WDemaagd Ross E · Middleville, MIBuilt 1962 · S/N 28-723 N7041CWayman Christopher Paul · Hyde Park, NYBuilt 1975 · S/N 28-7625067 N7041WRoth Isaac J · Ontario, WIBuilt 1962 · S/N 28-724 N7042CBr Flyers Club LLC · Baton Rouge, LABuilt 1975 · S/N 28-7690052 N7043CRellinger Michael · Venice, FLBuilt 1975 · S/N 28-7690053 N7043RHolst Thomas C · Pleasant Hope, MOBuilt 1966 · S/N 28-21740 N7044CPappas Tevis · Atlanta, TXBuilt 1975 · S/N 28R-7635092 N7044RSalzer Vaughn R · Ashley, NDBuilt 1966 · S/N 28-21741 N7045GBig Rock Aviation LLC · Big Rock, ILBuilt 1976 · S/N 32R-7680272 N7045R509 Aviation LLC · Lewes, DEBuilt 1966 · S/N 28-21742 N7045WCooksey Don R · Newcastle, WYBuilt 1962 · S/N 28-800 N7046RRegistration Pending · Vero Beach, FLRegistration pendingBuilt 1966 · S/N 28-21743 N7046WStreed Gwain E Trustee · Christmas Valley, ORBuilt 1962 · S/N 28-802 N7047RCoulter Frank R · Cygnet, OHBuilt 1966 · S/N 28-21744 N7047WApflight LLC · Naples, FLBuilt 1963 · S/N 28-793 N7048ROdonnell Bernard A · Wilbraham, MABuilt 1966 · S/N 28-21746 N7048WHisle Kenneth Ray · Winchester, KYBuilt 1962 · S/N 28-806 N7049WAuto Ink · San Diego, CABuilt 1962 · S/N 28-809 N704FLBabri Masood A · Lorton, VABuilt 1972 · S/N 28-7225256 N704MRCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841181 N704NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843873 N7051RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21749 N7052FStephens Racquel C · Laguna Niguel, CABuilt 1976 · S/N 28-7790179 N7052RSell Carl N · Spanaway, WABuilt 1966 · S/N 28-21750 N7052WPuskala Thomas S · Iron River, MIBuilt 1962 · S/N 28-817 N7053WRed Rock Flying School LLC · Mesa, AZBuilt 1962 · S/N 28-805 N7054WLanguage Gert Johannes · Hays, KSS/N 28-820 N7055RRegistered aircraftBuilt 1966 · S/N 28-21754 N7055WRickard Donald L · Rowland Hts, CABuilt 1962 · S/N 28-823

Back to AD 87-08-08 R3