Skip to content

Registered aircraft · 20,481

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N86510Ungersma Thomas Robert · Belgrade, MTBuilt 1973 · S/N 18261938 N86526Hill Farms Inc · Drexel, MOBuilt 1973 · S/N 18261941 N8652TEagles Wings Inc · San Angelo, TXBuilt 1960 · S/N 52552 N86536Moes Crop Dusting Service Inc · Marysville, CABuilt 1973 · S/N 18261942 N86541Hyppa Russell F · Cook, MNFirst renewal noticeBuilt 1973 · S/N 18261943 N8656THacker Arlen H · Sandusky, MIBuilt 1960 · S/N 52556 N8657XFlolid Ron · Little Falls, MNBuilt 1961 · S/N 18051057 N8658XNorth Mountain Lake Corp · Wilmington, DES/N 18051058 N8659TMclenaghan Alvin N · Phoenix, AZBuilt 1960 · S/N 52559 N865CWSouthern Aviation · Anchorage, AKFirst renewal noticeBuilt 2005 · S/N 18281537 N865PHPhe Inc · Roseville, CABuilt 1968 · S/N 18259353 N865TCQuinault Aviation LLC · Priest River, IDS/N 18282276 N865WMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2013 · S/N 20608352 N8662THatfield Dominic · Mesa, AZBuilt 1960 · S/N 52562 N8663TBruni Design Inc · Greenacres, WABuilt 1960 · S/N 52563 N8664TGray Eric W · Erie, COBuilt 1960 · S/N 52564 N8665XEstes Aviation LLC · Vicksburg, MSBuilt 1961 · S/N 18051065 N8666TEvery Rex R · Wilburton, OKBuilt 1960 · S/N 52566 N8668TWagoner Thomas H · Clarinda, IABuilt 1960 · S/N 52568 N8669THall David T · Baton Rouge, LABuilt 1960 · S/N 52569 N866TTSgw Aviation LLC · Hastings, MIBuilt 2018 · S/N 18283042 N8670TLovegreen Kenneth · Naples, FLS/N 52570 N8671TSchafer Timothy R · Soldotna, AKS/N 52571 N8673TJensen Dennis H · Askov, MNBuilt 1960 · S/N 52573 N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474 N8675TWakefield Bradley E · Rogersville, MOBuilt 1960 · S/N 52575 N8676TCasciola Diana M · East Branch, NYBuilt 1960 · S/N 52576 N8676XEdwards Flying Service Inc · Leland, MSBuilt 1961 · S/N 18051076 N8677TKowachek Edwin J · Missoula, MTBuilt 1960 · S/N 52577 N8678XDorman Richard E · Mesa, WABuilt 1961 · S/N 18051078 N8679TOnshore Aviation LLC · Taylors, SCBuilt 1960 · S/N 52579 N8679XHigh Mountain Air LLC · Missoula, MTBuilt 1961 · S/N 18051079 N8680TD2w Enterprise LLC · Miami Lakes, FLS/N 52580 N8680XStevens William C · Ashland, MTBuilt 1961 · S/N 18051080 N8682TBushong Charles L Jr · Jackson, WYBuilt 1960 · S/N 52582 N8684TMacnealy Bradly S · Isola, MSBuilt 1960 · S/N 52584 N8686QWaters & Associates Inc · Bellaire, TXS/N U20603468 N8687TKinney Christopher G · Beresford, SDBuilt 1960 · S/N 52587 N8688ZPowell Leo · Villa Park, CAS/N P206-0488 N868LBPatriot Leasing LLC · Abilene, TXBuilt 1969 · S/N 18259911 N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168 N8690TFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 52590 N8693TEgmond Aircraft LLC · Lewes, DEBuilt 1960 · S/N 52593 N8695TAtarah LLC · Tucson, AZBuilt 1960 · S/N 52595 N8697XAmboni Sinesio Jr · Wasilla, AKBuilt 1962 · S/N 18051097 N8698TTimwatco LLC · Orland, CABuilt 1960 · S/N 52598 N8699TSims William L · Hobart, OKBuilt 1960 · S/N 52599 N8699XFronius Douglas L · Poway, CABuilt 1962 · S/N 18051099 N8699ZEdaero LLC · Bangor, MEBuilt 1968 · S/N P206-0499 N869JRRiver City Flying Club · Glen Allen, VABuilt 1968 · S/N 18259441

Back to AD 84-10-01 R1