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.

N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096 N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212 N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464 N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213 N517APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843753 N517AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020046 N517BWWomer Blaine A · Hemet, CABuilt 2007 · S/N 2843652 N517FDJoyner James M · Eagle River, AKBuilt 2001 · S/N 3257263 N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098 N517MMMiller Jeremy M · Hazle Township, PABuilt 1978 · S/N 32R-7885191 N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264 N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466 N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035 N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216 N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469 N5182SFoster Tyler R · Levelland, TXS/N 28-7105036 N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037 N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472 N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038 N5186WQuick Janice L · Wrightwood, CABuilt 1961 · S/N 28-221 N5187LMcclelland Kip · Douglas, GAS/N 28-4475 N5187WGardner Robert E · Dixon, CABuilt 1961 · S/N 28-222 N5188SMiller Kaci · Bullhead City, AZBuilt 1970 · S/N 28-7105046 N5189LMicic Miodrag · Lake Elsinore, CABuilt 1968 · S/N 28-5129 N5189SBender Douglas E · Kendallville, INBuilt 1970 · S/N 28-7105049 N518AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2021 · S/N 28020047 N518BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842258 N518BW8bravo Wiskey LLC · New Liberty, KYBuilt 1974 · S/N 28-7405240 N518DPN518dp LLC · Spruce Pine, NCBuilt 1966 · S/N 32-765 N518JSDubbs Chad T · Naples, FLBuilt 2003 · S/N 3246212 N518MWUrban Kenneth J · Foxboro, MAS/N 2844105 N5190LKing Samantha M · Mcdonough, GABuilt 1967 · S/N 28-4479 N5190SRobinson Richard D · Montclair, CABuilt 1970 · S/N 28-7105050 N5191LGravley Kevin · Wiggins, MSBuilt 1967 · S/N 28-4480 N5192LKirkpatrick William J · Tyrone, PAS/N 28-4481 N5192SCxo Time Builder LLC · Magnolia, TXBuilt 1970 · S/N 28-7105052 N5193LC And H Aviation LLC · Madison, MSBuilt 1967 · S/N 28-4482 N5193SEagle Christopher S · Columbus, GABuilt 1970 · S/N 28-7105053 N5194LByham Shawn Grant Charles · Santa Margarita, CABuilt 1967 · S/N 28-4483 N5195SToby Aviation Inc · Pigeon Forge, TNBuilt 1970 · S/N 28-7105055 N5195WQuenzer Floyd N · Fresno, CABuilt 1961 · S/N 28-230 N5197FKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1976 · S/N 28-7790086 N5197LSeuferer Kevin J · Osceola, IABuilt 1967 · S/N 28-4487 N5197SHaertlein Lauren L · Annapolis, MDBuilt 1970 · S/N 28-7105048 N5199LPrince Bros Aviation LLC · North Canton, OHBuilt 1967 · S/N 28-4489 N5199STacoma Sky LLC · Winston Salem, NCS/N 28-7105058 N519AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020048 N519JLakeland Tower Leasing Co · Traverse City, MIBuilt 1968 · S/N 28R-30376 N519RGRegistration Pending · Kokomo, INRegistration pendingS/N 28R-35097 N51AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 32R-8413017

Back to AD 87-08-08 R3