Skip to content

Registered aircraft · 22,413

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.

N3836KValarchi Air Aviation LLC · Lewes, DEBuilt 1967 · S/N 28-23743 N3836WOconnell Richard M · Dothan, ALBuilt 1966 · S/N 32-771 N38373Outbound Aviation LLC · Dover, DEBuilt 1977 · S/N 28-7716247 N3837TRemsberg Charles · University Place, WABuilt 1967 · S/N 28R-30155 N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091 N38385Wahl Michael John · Jefferson, IABuilt 1977 · S/N 28R-7703211 N38388Hosanna Industries Inc · Gibsonia, PABuilt 1977 · S/N 32R-7780422 N3838TFundamentals Aircraft Leasing LLC · Erie, PABuilt 1967 · S/N 28R-30157 N38394Wall Jeffrey L · Goffstown, NHBuilt 1977 · S/N 28-7790548 N3839TN3839t LLC · Copley, OHS/N 28R-30158 N383CSven 1 LLC · Center Moriches, NYBuilt 2001 · S/N 3257258 N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098 N383GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881118 N383NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881829 N383PTFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881603 N38409Straub Craig W · San Martin, CABuilt 1977 · S/N 28-7790255 N38411N38411 LLC · Bellevue, WABuilt 1977 · S/N 28-7790356 N38412Rekaa Enterprises LLC · Paragould, ARBuilt 1977 · S/N 28-7716251 N3841WHirschler Steven · Big Bear Lake, CABuilt 1966 · S/N 32-779 N38421Sale Reported · Ephrata, WASale reported, pending cancellationBuilt 1977 · S/N 28-7790551 N3842WAnderson David A · Omaha, NEBuilt 1966 · S/N 32-780 N38430Vp Aviation Inc · Bloomington, INS/N 32R-7780426 N38433Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716254 N38434Wheeler Jeffrey Scott · Hampstead, NCBuilt 1977 · S/N 28-7790553 N3843WStrong Jason · Agency, MOBuilt 1966 · S/N 32-781 N38440Decoria Dustin E · Kennewick, WABuilt 1977 · S/N 28R-7703218 N38444Middlebrook Lary · Lakeside, CABuilt 1977 · S/N 28R-7703221 N38448Orphans Hands Inc · Clinton, TNBuilt 1977 · S/N 32R-7780428 N3844KSymonds Gregory S · Old Lyme, CTBuilt 1967 · S/N 28-23746 N3844MN3844m LLC · New Canaan, CTBuilt 1978 · S/N 32R-7885016 N38457Registration Pending · Phoenix, AZRegistration pendingBuilt 1977 · S/N 28R-7737094 N3845TBakrevski Lupcho · Valparaiso, INBuilt 1967 · S/N 28R-30165 N3846Osyka LLC · Sheridan, WYBuilt 1967 · S/N 28R-30167 N38468Emmons Kevin D · Vincennes, INBuilt 1977 · S/N 28R-7703225 N38469Pathfinder One Holdings LLC · Huntington Beach, CAFirst renewal noticeBuilt 1977 · S/N 28-7710055 N38476Bcdc Farms Inc · Sudan, TXS/N 32R-7780433 N38477California In Nice Inc · San Jose, CABuilt 1977 · S/N 28-7725282 N38478Pa28 LLC · Sebastian, FLBuilt 1977 · S/N 28-7725283 N3847TBay Air Inc · Bay City, MIBuilt 1967 · S/N 28R-30168 N38480Klose Frank · Rochester Hills, MIBuilt 1977 · S/N 28-7716260 N38483Kdrd Holdings LLC · Texas City, TXS/N 28-7790556 N38485Duke Kyle N · Laurel, MTS/N 28R-7703226 N38486Lone Tree Aero LLC · Lone Tree, COBuilt 1977 · S/N 28R-7703228 N3848TNextgen Flight Acacemy Inc · Riverside, CAS/N 28R-30169 N38492Toureau John H · Chesterfield, MIBuilt 1977 · S/N 28-7716261 N38494Hannon Joseph S · Franklin, NHBuilt 1977 · S/N 28-7716262 N38495St Peter Christopher E · San Mateo, CABuilt 1977 · S/N 28R-7703229 N384BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010038 N384DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843846 N384GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881430

Back to AD 87-08-08 R3