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.

N347MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881417 N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571 N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575 N3480QAdcock Curtis D · Westerville, OHS/N 28-7725229 N3481WSandpiper Air LLC · Charles Town, WVBuilt 1966 · S/N 32-358 N3483WSale Reported · Lubbock, TXSale reportedBuilt 1966 · S/N 32-361 N3485WKemp James A · Deland, FLBuilt 1966 · S/N 32-363 N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701 N3486WSteele Jackie L · London, KYBuilt 1966 · S/N 32-364 N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159 N3488MStrand Laird W · Appleton, WIBuilt 1978 · S/N 28R-7803173 N3488WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N 32-367 N3489KGfh LLC · Zillah, WABuilt 1967 · S/N 28-23582 N348DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843841 N348MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881418 N348RPWright-Piros Ruth · Carlisle, IABuilt 1979 · S/N 32-7940186 N3492WMyers Andrew John · Wadsworth, OHS/N 32-372 N3493RValente Joseph · Sun Lakes, AZBuilt 1970 · S/N 28-5703 N3493WVerser James A · Greers Ferry, ARBuilt 1966 · S/N 32-373 N3494WHarrison Brett A · Fishers, INBuilt 1966 · S/N 32-374 N3497WRobb Kirk C · Abingdon, ILBuilt 1966 · S/N 32-377 N3498WKanz Robin Lea · Woodway, TXBuilt 1966 · S/N 32-378 N3499WAviator Solutions LLC · Oregonia, OHBuilt 1966 · S/N 32-379 N349BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881690 N349DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843842 N349ERWatkins Noble Marvin II · Port Saint Lucie, FLBuilt 1967 · S/N 28-3932 N349MAMa Sammy · S San Fran, CABuilt 2004 · S/N 3257349 N349MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881419 N349NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881902 N349SBSkyfusion II LLC · Atlanta, GABuilt 1977 · S/N 32R-7780480 N34DLAdlava LLC · Dover, OHBuilt 1966 · S/N 32-527 N34DSMachado Rocha Conrado · Aventura, FLBuilt 1984 · S/N 28R-8431019 N34JCA2b Aviation LLC · Newark, OHBuilt 1978 · S/N 32-7840198 N34MALk Air Inc · Arlington, WAS/N 32-40219 N34MVElysium Fleet Mgmt LLC · Menlo Park, CABuilt 1983 · S/N 32R-8413006 N34PTJentone Aviation LLC · Aber Prov Grd, MDBuilt 1974 · S/N 28R-7535029 N34WTT & S Aviation LLC · Lavonia, GAS/N 28-7515133 N34XTGwk Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 3255034 N3500WAerotyne International LLC · Prattville, ALBuilt 1966 · S/N 32-381 N3501WObrien Matthew A · North Platte, NEBuilt 1966 · S/N 32-382 N3502MRyskoski Randall J · Germantown, WIBuilt 1978 · S/N 28-7890307 N3502WN3502w LLC · Stephenville, TXBuilt 1966 · S/N 32-383 N3503KRunyon Michael · Charlotte, NCS/N 28-23591 N3508KTurnquest Alexis A · West Valley City, UTS/N 28-23594 N350BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881691 N350CAMajors Donald G Jr · Cave Creek, AZBuilt 2002 · S/N 3257279 N350MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881439 N350MLPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2843594 N3510KMcardle Daniel C II · Hereford, AZBuilt 1967 · S/N 28-23596 N3510WWhite Frank M · Haines, AKBuilt 1966 · S/N 32-392

Back to AD 87-08-08 R3