Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301 N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303 N2045NChristensen Tyler R · Red Bluff, CABuilt 1958 · S/N 186771 N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308 N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309 N2046CTexflight LLC · Beaumont, TXBuilt 2001 · S/N 0127 N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092 N2046LRegistration Pending · Bonham, TXRegistration pendingBuilt 1976 · S/N MC-433 N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443 N20470Dameron Cleveland Forrester · Wicomico Church, VABuilt 1972 · S/N 17261313 N20471Cp Aircraft Leasing LLC · Danville, CABuilt 1972 · S/N 17261314 N20472N20472 LLC · Opa Locka, FLBuilt 1972 · S/N 17261315 N20474Voinovich John · Ogden, UTBuilt 1972 · S/N 17261317 N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899 N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131 N2047QMeersma Montgomery D · Atlanta, GABuilt 1973 · S/N 177RG0447 N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324 N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327 N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329 N20487Point To Point Air LLC · Arlington, WAS/N 17261330 N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331 N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904 N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857 N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244 N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333 N20491Ross Johnathan M · Eagle River, AKBuilt 2002 · S/N 002 N20494Aviation Group Jmj Inc · Callahan, FLS/N 17261337 N20495Pitts Dan O · Soldotna, AKBuilt 1988 · S/N 1045 N20496Hess Garrett J · Fullerton, CABuilt 1973 · S/N 17261339 N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234 N2049QDdv Equipment Leasing LLC · Cheyenne, WYBuilt 1973 · S/N 177RG0449 N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445 N204BLO'Neil William Jerome · Richland, WABuilt 2012 · S/N WJO 003 N204BPBarbers Point Flight School LLC · Kapolei, HIFirst renewal noticeBuilt 2019 · S/N 104/US N204CMMorgan Kenneth J · Norridgewock, MEFirst renewal noticeBuilt 1975 · S/N 17265224 N204DKElgin John M · Cody, WYBuilt 2002 · S/N 60285 N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119 N204GACoen Brady · Wiley, COBuilt 1997 · S/N 200-9724F N204GLChrist Robert D · Mandeville, LABuilt 2014 · S/N 1204 N204HWNordman Marvin J · Great Bend, KSBuilt 2004 · S/N 25151 N204KKLofstrom Ashley N · Wasilla, AKBuilt 1989 · S/N 1232 N204LCUtah State University · Logan, UTBuilt 2004 · S/N 10248 N204MATsiu LLC · Wilmington, DEBuilt 2000 · S/N 2075 N204MMAvest Ltd · Hilltop Lakes, TXS/N 24-0718 N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844 N204RJFlying Hoosier Js LLC · Carmel, INBuilt 2004 · S/N 1375-2004 N204RKHermann Ron A · Sarasota, FLBuilt 1985 · S/N 28-8611003 N204RVCollette John D · Las Vegas, NVBuilt 1999 · S/N 832 N204SDOstern Mark Lynn · Rapid City, SDS/N 958-2004 N204SGSquillace Daniel J · Cary, NCBuilt 2005 · S/N 40.482

Back to AD 81-18-04 R2