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.

N8058MMaxfield Aviation LLC · Seattle, WABuilt 1976 · S/N 18264534 N805AJMoyer Aviation Inc · Ulysses, KSS/N 20601769 N805SLCounty Of San Luis Obispo Sheriffs Office · San Luis Obispo, CABuilt 1982 · S/N 18268271 N8060ZMason Michael · Anchorage, AKBuilt 1968 · S/N 18051992 N8061ZCarter Kristopher W · Bellingham, WABuilt 1965 · S/N U206-0461 N8063EHale Mitchell D · Chugiak, AKS/N U2060926 N8065MStoll Albert G · Healdsburg, CABuilt 1976 · S/N 18264536 N8065ZZulu Forty One LLC · Anchorage, AKS/N U206-0465 N8066ZTevik Michael A · Provo, UTBuilt 1965 · S/N U206-0466 N806CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283104 N806HUAstra Engineering LLC · Twin Falls, IDBuilt 1979 · S/N U20605215 N806THFvx Research · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282266 N8070ZRivers Larry R · Talkeetna, AKBuilt 1965 · S/N U206-0470 N8076ZHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0476 N807VROrton Thomas L · Clifford, MIBuilt 2007 · S/N 18281926 N807WCEt Fly Home LLC · Auburn, ALBuilt 1977 · S/N 21061775 N807XMrair LLC · Lewes, DEBuilt 1961 · S/N 18253207 N8081XHibdon Robert R · Jefferson City, MOBuilt 1967 · S/N 18258166 N8086VSchmitt Rudy · Brookshire, TXS/N 188-0336 N808BCMahanawai Lele LLC · Honolulu, HIBuilt 1970 · S/N 18260273 N808BPChemtech-Engineering Inc · Racine, WIBuilt 2004 · S/N 18281455 N808DWHall Danny J · Torrington, CTBuilt 2001 · S/N 18281044 N808FSBradley Supply Company LLC · Mesquite, NVS/N 21061586 N808RLCtr Assets LLC · Dawsonville, GABuilt 1963 · S/N 205-0467 N808ZTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608236 N8091ZFahlbusch Marius J · Snohomish, WABuilt 1966 · S/N U206-0491 N8097FBlue Sky Powers LLC N8097f LLC · Dover, DES/N U2060497 N809CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281222 N809EMDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608213 N809GTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608245 N809HWDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608248 N809KPDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608249 N809LNDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608251 N809NDDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608219 N809PGDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608190 N809QJDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608209 N809RHDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608210 N809SEDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608208 N809TTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608211 N809USDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608231 N809VADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608232 N80AARegistered aircraftFirst renewal noticeBuilt 1964 · S/N 18051426 N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548 N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425 N80HXAthans Holdings LLC - Series 180 · Lake In The Hills, ILS/N 18053035 N80JWMorgan Philip H · Anchorage, AKBuilt 1961 · S/N 18051018 N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467 N80PELakepoint Aviation LLC · Augusta, KSBuilt 2004 · S/N 18281472 N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014 N80WCAir-Quip LLC · Boulder City, NVBuilt 1981 · S/N 18267838

Back to AD 84-10-01 R1