Skip to content

Registered aircraft · 245

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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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.

N320TTCarroll Richard J · Pocatello, IDBuilt 1966 · S/N 320E-0081 N320VCDelta Three Air Services Inc · Burton, OHBuilt 1966 · S/N 320E-0016 N3239Q92nd West Aviation Inc · Lonoke, ARBuilt 1967 · S/N 401-0039 N3264QWilton William H · Kailua Kona, HIBuilt 1967 · S/N 401-0064 N3268QSuperior Food Distributors LLC · Naples, FLBuilt 1967 · S/N 401-0068 N3304QMcnutt Brian K · Mojave, CAS/N 320D0104 N3308QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 320D0108 N3309QB & R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 320D0109 N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115 N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116 N3317QSkynight 17q LLC · Roseville, CABuilt 1966 · S/N 320D0117 N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118 N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119 N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030 N3325QWinrick LLC · Flagstaff, AZS/N 320D0125 N337PLMaglaughlin Ronald D · Udall, KSBuilt 1969 · S/N 402A0039 N3405QHardin David A · Tukwila, WABuilt 1966 · S/N 320E-0005 N3412QPoulsen Melvin J · Orem, UTS/N 320E0012 N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017 N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037 N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044 N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052 N3458QIngram John · Los Angeles, CABuilt 1966 · S/N 320E-0058 N3474QLyle Timothy · Lakewood Ranch, FLBuilt 1966 · S/N 320E-0074 N3478QCsc Aviation LLC · Parker, COS/N 320E-0078 N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089 N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091 N3492QLadet William D · Las Vegas, NVS/N 320E-0092 N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094 N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095 N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125 N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795 N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126 N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071 N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215 N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114 N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803 N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106 N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137 N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044 N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000 N401AKKulon Andrew · Wyanet, ILS/N 401A0090 N401ATBlum John J · Montgomery, TXBuilt 1966 · S/N 401-0010 N401AZTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 401B-0018 N401BTKlena Bradley D · Maryville, TNS/N 401A0002 N401CAGlenn Roger H · Pacifica, CABuilt 1969 · S/N 401A-0025 N401CFStuewe Charles D · Chino Hills, CABuilt 1967 · S/N 401-0115 N401KN401k LLC · Lonoke, ARBuilt 1967 · S/N 401-0038 N401LMMission Flight · El Monte, CAS/N 401B-0209 N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159

Back to AD 70-03-04 R1