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.

N47714Bradford Matthew Corin · Murrieta, CAS/N 28-7890088 N47718Ap Midway Inc · Palos Hills, ILBuilt 1977 · S/N 28-7816127 N47719Webb Bennie Kenneth · Fitzgerald, GABuilt 1977 · S/N 28-7816128 N4771LHenderson Brian K · Redding, CABuilt 1967 · S/N 28-4103 N47723Six Drew · Clinton, OHS/N 28R-7837002 N47726Pier To Plateau Aviation Services LLC · Wilmington, DES/N 28R-7803005 N47728Jr Aircraft Services LLC · Oxford, MIBuilt 1977 · S/N 28R-7803006 N4772LValiair Lc Trustee · Casper, WYBuilt 1967 · S/N 28-4104 N47737N47737 Holdings LLC · Gonzales, LABuilt 1977 · S/N 28-7890129 N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003 N47739Tnl Management LLC · Cullman, ALBuilt 1977 · S/N 28R-7803008 N47740Media Stew LLC · Carson City, NVBuilt 1977 · S/N 28R-7803009 N47742Jmd Enterprises LLC · Thompsons Station, TNBuilt 1977 · S/N 28R-7803011 N47743Majic T Air LLC · Bradfordwoods, PABuilt 1977 · S/N 32R-7880020 N4775F2 Fly Aviation LLC · Short Hills, NJBuilt 1976 · S/N 32-7640121 N4775LWadkins Chris H · Plummer, IDBuilt 1967 · S/N 28-4109 N47761Engholm Jeffrey H · Bauxite, ARBuilt 1977 · S/N 28R-7803012 N47763Premier Management Co · Mobridge, SDBuilt 1977 · S/N 28R-7803014 N47764Wl Aviation LLC · Olney, MDBuilt 1977 · S/N 32R-7880021 N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132 N47768Registered aircraftBuilt 1977 · S/N 28-7816133 N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110 N47771Harris Richard P · Kings Park, NYS/N 28-7890135 N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137 N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111 N4778LGarrett Russell K · Hazen, NDS/N 28-4112 N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017 N477DMiller Clark · Grapevine, TXBuilt 1977 · S/N 32R-7780367 N477HPWilliams Kerry Brent · Seminole, TXBuilt 2006 · S/N 3257429 N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030 N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200 N477RRadtke Jeffrey A · Norwalk, CTBuilt 2003 · S/N 3232006 N47805Premier Aviation LLC · Sioux Falls, SDS/N 28R-7803016 N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115 N47810Nrg Systems N W LLC · Gresham, ORBuilt 1977 · S/N 28R-7803019 N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134 N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136 N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116 N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139 N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140 N47826Rogerson Andrew C · Kingsland, TXBuilt 1977 · S/N 28R-7803021 N47827Alford James L · Mckinney, TXBuilt 1977 · S/N 28R-7803022 N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204 N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138 N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139 N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141 N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006 N4783LSikka Dhruv · Lutz, FLBuilt 1967 · S/N 28-4118 N47842S&L Farm And Ranch LLC · Roseburg, ORS/N 28R-7803025 N4784LDelta Sierra LLC · Naples, FLBuilt 1967 · S/N 28-4119

Back to AD 87-08-08 R3