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.

N32898Spitaleri Robert F · Winter Haven, FLS/N 28-7525126 N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146 N3289WShandon Aviation LLC · Lewes, DES/N 32-122 N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115 N328HPAlan C Perry LLC · Lake Charles, LABuilt 2000 · S/N 3257166 N328MASs Aviation LLC · Wichita, KSFirst renewal noticeBuilt 1974 · S/N 28R-7435035 N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164 N32903Foxtail Aviation LLC · Orefield, PABuilt 1974 · S/N 28-7515271 N32904Sheidler Randy L · Gallipolis, OHBuilt 1974 · S/N 28-7515272 N32906Benson Brian R · Mauston, WIBuilt 1974 · S/N 28-7515273 N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147 N32919Mbap LLC · Salt Lake City, UTS/N 32-7540074 N3292WOldenkamp Daryl · Hermosa Beach, CAS/N 32-125 N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276 N32934Robert Craig LLC · Wilmington, DEBuilt 1975 · S/N 32-7540075 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264 N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279 N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265 N32956Meritt Kendall E · Wayne City, ILBuilt 1974 · S/N 28-7510035 N3295WChapman Daniel H Jr · Ontario, CABuilt 1965 · S/N 32-128 N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282 N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106 N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103 N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283 N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284 N32990Trident Aircraft Leasing LLC · Easton, MDBuilt 1974 · S/N 28-7515285 N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108 N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104 N32998Clark Jeffrey Ryan · Greenville, KYBuilt 1975 · S/N 32-7540079 N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270 N3299WLowe Russell · Navarre, FLS/N 32-133 N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991 N329HPRight Rudder LLC · Halifax, PABuilt 2000 · S/N 3246166 N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574 N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512 N329RWHansen Glenn J · Fairfield, CTBuilt 2007 · S/N 3232073 N32BVH Randal Brennan Pa · Vero Beach, FLBuilt 1972 · S/N 32-7240084 N32BZManganaro John G II · Manvel, TXBuilt 1973 · S/N 32-7300014 N32CZElk Mountain Rentals Inc · Waynesville, NCBuilt 2003 · S/N 3255011 N32EJFox Jason Ross · Buckley, WABuilt 1967 · S/N 28R-30287 N32HFFluid Process Automation LLC · Alliance, OHS/N 32R-7885186 N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391 N32KHN32kh LLC · Quincy, WAS/N 287790384 N32MGPoor Boy Aero LLC · Seminole, TXBuilt 1982 · S/N 32R-8329003 N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023 N32PDAsp Victor · Shoreline, WABuilt 1973 · S/N 28R-7435091 N32RFPulford Robert A · Barkhamsted, CTBuilt 1978 · S/N 32-7800001 N32RTKnop Jeffrey Brian · Mount Juliet, TNBuilt 1978 · S/N 32R7987008 N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174

Back to AD 87-08-08 R3