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.

N3547KAlexander Robert D · Ardmore, OKBuilt 1967 · S/N 28-23622 N3547MBernstein Matthew D · North Charleston, SCBuilt 1978 · S/N 28-7816354 N3547WNatwick Joel T · Port Alsworth, AKS/N 32-434 N354BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881777 N354JHArrow Group 5 LLC · Lake Saint Louis, MOBuilt 1974 · S/N 28R-7435233 N354MAAir Shares LLC · Casper, WYBuilt 2003 · S/N 2843545 N354MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881501 N3552MArcher Enterprises Inc · Sac City, IABuilt 1978 · S/N 28-7890313 N3552WTwo Sixty Aviation LLC · Wilmington, NCBuilt 1966 · S/N 32-439 N3553MIxi LLC · West Bloomfield, MIBuilt 1978 · S/N 28-7890314 N3553WVarn Samuel G · Thomasville, GABuilt 1966 · S/N 32-441 N3554MWacker Peter K · Marietta, GAS/N 28R-7837123 N3554WPerkins Chas L · Warsaw, MOBuilt 1966 · S/N 32-442 N3555WF&F Aviation LLC · Worthington, OHS/N 32-443 N3557KEastern Aeroworks LLC · Punxsutawney, PAS/N 28-23627 N35590Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 32R-8013020 N3559CDelta Blue Line LLC · Collierville, TNBuilt 1979 · S/N 32-7940279 N3559DStuder Edward J · Ballinger, TXBuilt 1979 · S/N 28-8011057 N3559MMoyer Josiah E · Paradise, PABuilt 1978 · S/N 28R-7837124 N3559QIndependence Air LLC · Advance, NCBuilt 1979 · S/N 32R-8029022 N3559ULewis Tyler Dean · Bullard, TXBuilt 1979 · S/N 32R-8013018 N3559WSherlin Grover W · Garland, TXBuilt 1966 · S/N 32-448 N3559XSpon Water Consulting LLC · South Beloit, ILBuilt 1979 · S/N 32R-8013019 N355AJTexas Flyers LLC · Amarillo, TXBuilt 1978 · S/N 28R-7803282 N355CTRegistration Pending · Eldersburg, MDRegistration pendingS/N 32R-7780486 N355DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843843 N355JHEmm USA Inc · Lewes, DEBuilt 1973 · S/N 32-7340116 N355LGLilienthal Michael · Las Vegas, NVBuilt 1969 · S/N 28-5462 N355MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881502 N3560ECrawford James M · Sparta, MIBuilt 1979 · S/N 28-8016186 N3560MBeyond Grateful LLC · Frisco, COBuilt 1978 · S/N 28R-7803177 N3560VAmdor John E · Harlan, IABuilt 1979 · S/N 28-8090182 N35611Schutte Farm Inc · Burlington, COS/N 28R-8031032 N3561WSchulz Beverly A · Merrill, WIBuilt 1966 · S/N 32-451 N35621Loza Guillermo · Acton, CABuilt 1979 · S/N 32R-8013022 N3562GTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1979 · S/N 28-8090186 N3562LAndersen Kim · Yucaipa, CABuilt 1980 · S/N 28-8090187 N35636Carreno Miriam · Portland, ORBuilt 1979 · S/N 28R-8031036 N3564DKar Aviation LLC · Indialantic, FLBuilt 1979 · S/N 32R-8013023 N3564NAbbott Aircraft Sales And Service LLC · Holts Summit, MOS/N 32R-8013024 N3564WWemyh Air LLC · Krum, TXBuilt 1966 · S/N 32-454 N35659Steele Aviation Inc · Walnut Cove, NCS/N 32-7940280 N3565KDb Dickinson Farms Inc · Brighton, IAFirst renewal noticeBuilt 1967 · S/N 28-23629 N3565MSix 5 Mike LLC · Shreveport, LABuilt 1978 · S/N 32-7840067 N3566PDobbin Douglas G · El Paso, TXBuilt 1979 · S/N 32R-8013028 N35671Clemons Preston J · Andover, KSBuilt 1979 · S/N 28-8016204 N35679Mid Valley Flying LLC · Progreso, TXBuilt 1979 · S/N 32R-8029030 N35689Faulkison Brian S · Watkins, COBuilt 1979 · S/N 28-8090193 N3569DFtaviation LLC · Chantilly, VABuilt 1979 · S/N 28-8090168 N3569QTerry Woodard Enterprises Inc · Beaumont, TXBuilt 1977 · S/N 28R-7703115

Back to AD 87-08-08 R3