Skip to content

Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887 N58882Coburn Shawn · Dos Palos, CABuilt 1973 · S/N 18262371 N58884Snider Aaron A · Ludington, MIBuilt 1973 · S/N 18262373 N58885Livengood John M · Prescott, AZBuilt 1973 · S/N 18262374 N58888Ducommun Robert C · New York, NYBuilt 1973 · S/N 18262377 N5888ADahlberg James C · Ogilvie, MNS/N 28488 N5888CCwf Enterprises Inc · Grove, OKS/N U20605888 N5888RTepper Steve D · Stayton, ORBuilt 1965 · S/N 17253557 N5889BLeitz Steven C · Cathlamet, WABuilt 1956 · S/N 33889 N5889RPatkotak Crawford A · Barrow, AKS/N 17253558 N588BRTraining Planes LLC · Tampa, FLS/N 15281860 N588LCProdonor LLC · Phoenix, AZBuilt 1965 · S/N 17253895 N58909Plantation Farms Inc · Wall, TXFirst renewal noticeBuilt 1973 · S/N 18262390 N5890AMartin Jason L · Fort Worth, TXBuilt 1956 · S/N 28490 N5890BKilo Aviation LLC · East Peoria, ILBuilt 1956 · S/N 33890 N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390 N5890RYell Christopher R · Williamsburg, KYBuilt 1965 · S/N 17253559 N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391 N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560 N5891THutchison John N · Big Lake, AKBuilt 1964 · S/N 1850791 N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394 N58924Quicksilver Air Inc · Fairbanks, AKS/N 18262395 N58926Hawkeye Aviation Inc · Yakima, WABuilt 1973 · S/N 18262397 N5892THayden Daniel · North Pole, AKBuilt 1964 · S/N 185-0792 N58944Cassada Josh A · Charlevoix, MIBuilt 1973 · S/N 18262415 N58949M & M Aircraft LLC · Cresson, TXBuilt 1973 · S/N 18262420 N5894BFischer Alfred M DBA · Genoa City, WIS/N 33894 N5894RMurray Kevin D · Moneta, VABuilt 1965 · S/N 17253563 N58954Musheinesh Issa A · Bloomfield Hills, MIBuilt 1973 · S/N 18262424 N5895ADuncan Russell A · Glen Burnie, MDBuilt 1956 · S/N 28495 N5895RBernhard Sterling · Harper, TXBuilt 1965 · S/N 17253564 N5895THeligray LLC · Kalispell, MTBuilt 1964 · S/N 185-0795 N58960Regan Ed · Torrance, CABuilt 1973 · S/N 18262428 N58961Monteith Andrew W · Lebanon, PABuilt 1973 · S/N 18262429 N58964Likens Tony G · Longville, MNBuilt 1973 · S/N 18262432 N58967Whatsup LLC · Mccomb, MSBuilt 1973 · S/N 18262435 N5896AFox Black Enterprises Inc · Kilmarnock, VABuilt 1956 · S/N 28496 N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396 N5896RRegistration Pending · Florence, MSRegistration pendingBuilt 1965 · S/N 17253565 N58976Pennington Tony D · Corpus Christi, TXBuilt 1973 · S/N 18262439 N5897CGot Wings LLC · Woodbury, NYBuilt 1973 · S/N 18262437 N5897ECoral Breeze Aviation LLC · Hinsdale, ILS/N 18268337 N58981Skloss Anthony W · Edinburg, TXBuilt 1973 · S/N 18262441 N58989Texas Wings In The Air II LLC · Santa Teresa, NMBuilt 1973 · S/N 18262442 N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398 N58994Aviation Trust Co LLC Trustee · Oklahoma City, OKS/N 18262444 N58998Coach Aviation LLC · Dover, DES/N 18262446 N58999United Indian Missions DBA · Tucson, AZBuilt 1973 · S/N 18262447 N5899BRi Skydiving Aircraft LLC · Middletown, RIBuilt 1956 · S/N 33899 N5899RParrish Aviation Flight Academy LLC · Dallas, TXS/N 17253568

Back to AD 87-20-03 R2