Skip to content

Registered aircraft · 8,921

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N3041ZDunn Carrie B · Emporia, KSBuilt 1959 · S/N 22-6995 N3043ZMaria A Sklar Pa DBA Sklar Law Trustee · Fort Lauderdale, FLBuilt 1959 · S/N 22-6997 N3044ZRoberts Marvin L · Calhoun, GABuilt 1959 · S/N 22-6998 N3045ZColson Douglas J · Emmitsburg, MDBuilt 1959 · S/N 22-6999 N3046ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-7000 N3047BOregon Aero Academy Inc · Albany, ORBuilt 1978 · S/N 44-7995113 N3047ZRiffle David T · Woodinville, WABuilt 1960 · S/N 22-7001 N3048PMeginnes Mark A · Tucson, AZBuilt 1957 · S/N 23-959 N3048RAlbert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 44-7995242 N3048ZPalmatier Curt A · Montrose, PABuilt 1959 · S/N 22-7002 N3049PTaildragger Aero LLC · Saint John, WABuilt 1957 · S/N 23-961 N30521Sale Reported · New Bern, NCSale reported, pending cancellationBuilt 1978 · S/N 44-7995076 N3052DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995144 N3052ZSummer Aviation LLC · Eden Prairie, MNBuilt 1959 · S/N 22-7006 N3053ZSonntag Franklin T · Stevensville, MDBuilt 1959 · S/N 22-7007 N3054ZSandall Brian E · Lake Stevens, WABuilt 1959 · S/N 22-7008 N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013 N30608Christiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496180 N3061ZKell Thomas G · Anchorage, AKS/N 22-7016 N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017 N3063PWillis William P Trustee · New Palestine, INS/N 23-981 N3063ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7018 N3064ZReichlin Richard S · Traverse City, MIBuilt 1959 · S/N 22-7019 N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984 N306AKRobinson Thomas F II · Port Charlotte, FLBuilt 1966 · S/N 30-1253 N3070PParker Anthony C · New Ipswich, NHBuilt 1957 · S/N 23-988 N3073PPerry Edward Glen Trustee · Ozark, ARBuilt 1957 · S/N 23-991 N3073ZStrid Julius M · Winlock, WABuilt 1959 · S/N 22-7030 N3078ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7035 N3081PVan Zant Robert E · Salem, WIS/N 23-999 N3085YMarsh Aviation Of Marana Inc · Marana, AZFirst renewal noticeS/N 25-4265 N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144 N3088GRox Air LLC · Montgomery, OHBuilt 1963 · S/N 30-88 N3090AFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496183 N309WPMcmahon Peter · Brookfield, CTBuilt 1961 · S/N 24-2955 N30BMagill Terry K · Beach City, TXBuilt 1966 · S/N 30-1381 N30BTKarastamatis Thanassi · Collierville, TNS/N 22-1415 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59 N30JNDls Holdings Inc · Lewes, DEBuilt 1957 · S/N 30-1423 N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539 N30NWCenterline Aerospace Inc · Clermont, FLFirst renewal noticeBuilt 1964 · S/N 30-312 N30SHMedic Choppers LLC · Springdale, ARBuilt 1966 · S/N 30-1262 N30TJFiskars Equipment Co · Saint Joseph, MIBuilt 1965 · S/N 30-762 N30XTBurnette Ric A · Sebastian, FLBuilt 1967 · S/N 30-1644 N3103ESpartan Education LLC · Tulsa, OKBuilt 2004 · S/N 4496188 N3104CFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496190 N3107ZBauer Dereck R · Springfield, ORBuilt 1959 · S/N 22-7041 N3108ZRinehart John M · Shelbyville, INBuilt 1959 · S/N 22-7047 N3109ZMayer Michael · Milford, UTS/N 22-7048

Back to AD 85-02-05 R1