Skip to content

Registered aircraft · 4,001

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-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N356PLBongiorni Robert W · Burgettstown, PABuilt 1978 · S/N R1722987 N3573VShaules Daniel J · Billings, MTBuilt 1977 · S/N R1722258 N357NSKessler Garry A · Lansing, WVBuilt 1969 · S/N 33701222 N358Bipes Anthony · Forest Lake, MNBuilt 1967 · S/N 337-0737 N3587MWellspring Air Group LLC · East Helena, MTBuilt 1978 · S/N 28R-7803179 N3588MCavu Aviation LLC · Draper, UTBuilt 1978 · S/N 28R-7803180 N3589MGregory Kenneth C · Gilbert, AZBuilt 1978 · S/N 28R-7803181 N358XTubbs Randall E · Newfield, NYBuilt 1976 · S/N 6163C N3593RHoskins Earl R · Bryan, TXFirst renewal noticeBuilt 1965 · S/N M-757 N3594HKilo Sierra LLC · Harwich, MABuilt 1980 · S/N 25-0428 N359RCWingsleasing LLC · Wichita, KSBuilt 1977 · S/N R1722427 N35ARRaven Air LLC · Miami, FLFirst renewal noticeBuilt 1977 · S/N 347770254 N35GKPacific Flight Aviation LLC · Costa Mesa, CAS/N 3449174 N35RMSuell Tommy R · North Las Vegas, NVBuilt 1983 · S/N 06 N36049Koppenhaver Seth Tyson · Oro Valley, AZBuilt 1978 · S/N 34-7870287 N3605MIsland Bound LLC · Dunedin, FLBuilt 1978 · S/N 34-7870118 N36067Armor Corps Inc · Spring Hill, TNBuilt 1978 · S/N 28R-7803309 N36097Conner Don R · Hot Springs, SDFirst renewal noticeS/N 28R-7803310 N360DE360 Skyhigh LLC · Cedar Rapids, IABuilt 2006 · S/N 381-320-136 N360EZTurner Jeffrey K · Modesto, CABuilt 1995 · S/N SJ2146 N360GCHuelskamp Thomas · Fowler, KSBuilt 2012 · S/N 289-320-51 N36106Leaseair LLC · Wilmington, DEBuilt 1978 · S/N 34-7870293 N362HEMidamerica Jet Inc · Owensboro, KYBuilt 2002 · S/N 1263 N3630MAmercani Mahmoud · Fayetteville, GABuilt 1978 · S/N 28R-7803182 N3631MTrekjet LLC · Southington, CTBuilt 1978 · S/N 28R-7803183 N36345Altair Aircraft LLC · Gainesville, FLBuilt 1978 · S/N 34-7870321 N36369Eastern Aeroworks LLC · Punxsutawney, PABuilt 1978 · S/N 34-7870323 N3636HLasar Inc · Lakeport, CABuilt 1980 · S/N 25-0433 N36371Akridge Jeffry J · Moses Lake, WAS/N 34-7870324 N364Farmers Bank · Parsons, TNBuilt 1976 · S/N P3370243 N36482Fair Air Inc · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870335 N36487Steele Charles C · Hollandale, MSS/N 34-7870337 N36496Moseler Scott · Barrington, ILBuilt 1978 · S/N 28R-7803326 N3650HRoyal Horus Elevate LLC · San Antonio, TXBuilt 1980 · S/N 25-0434 N36536Sky High Investments LLC · Greenwood, INBuilt 1978 · S/N 34-7870341 N3653HDove Kenneth F · Danville, CABuilt 1980 · S/N 25-0435 N3654HThompson William D · Godley, TXBuilt 1980 · S/N 25-0436 N365XArmstrong Stefanie M · Anchorage, AKBuilt 1976 · S/N 6173C N3661HHamer Robert E · Beaumont, TXBuilt 1980 · S/N 25-0440 N3663HGould Ryan · Girdwood, AKBuilt 1980 · S/N 25-0441 N3664MEchtle Keith A · Castroville, TXBuilt 1978 · S/N 28R-7803184 N36696Ovajet Group Inc · Miami, FLBuilt 1978 · S/N 34-7870353 N3671HErickson Orchards Inc · Ritzville, WABuilt 1980 · S/N 25-0443 N36795Rudy Neal W · Peoria, ILBuilt 1978 · S/N 34-7870371 N367XBreuer Chad R · Lometa, TXBuilt 1976 · S/N 6165C N36822Bream Bruce L · Beachwood, OHBuilt 1978 · S/N 28R-7803345 N36827Thaviation LLC · Louisville, KYBuilt 1978 · S/N 34-7870374 N3699HBarnhardt Jerry · Stockton, CABuilt 1980 · S/N 25-0476 N369ACAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 34-7870095 N369ALInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 1552

Back to AD 81-13-10 R1