Skip to content

Registered aircraft · 40,394

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N7611GStaunton Curtis J · Tulelake, CABuilt 1970 · S/N 17259311 N7611LSteils Building Renovation And Management Inc · Lino Lakes, MNBuilt 1968 · S/N 384 N7611WRace Place Inc · Greenwood, INBuilt 1964 · S/N 28-1571 N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312 N7612RSamper Aviation LLC · Easton, PABuilt 1969 · S/N M-1235 N7612WGunn Michael Reid · Wilson, ARBuilt 1964 · S/N 28-1572 N7613DHendrickson Aaron C · Mazomanie, WIBuilt 1957 · S/N 22-5317 N7614DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5318 N7614RKull Phillip G · Monroe, MIBuilt 1969 · S/N M-1237 N7614WFerris Lawrence D · Valentine, NEBuilt 1964 · S/N 28-1575 N7615GWashington Samuel C · Washington, DCS/N 17259315 N7615WBittner Terry L · Woodbine, MDBuilt 1964 · S/N 28-1576 N7615ZRobinson Norman D II · Salt Lake City, UTBuilt 1966 · S/N 18-8398 N7616FBurgers Todd · Lagrange Hlds, ILBuilt 1976 · S/N 28-7715210 N7616RMalcom Brett W · Warner Robins, GABuilt 1969 · S/N M-1239 N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906 N7617DRunyan Colton C · Ashland, ALBuilt 1957 · S/N 22-5321 N7617FKeldahl William J · Copperhill, TNBuilt 1976 · S/N 28-7715211 N7617WWhirl'D Helicopters Inc · Sevierville, TNBuilt 1964 · S/N 28-1581 N7618SBraun Michael T · Oconomowoc, WIBuilt 1976 · S/N 923-76 N7618WExaltium Aviation LLC · Baltimore, MDBuilt 1964 · S/N 28-1582 N7619FAinsworth Cavin · Fort Towson, OKBuilt 1976 · S/N 28-7790194 N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319 N761CCHesston College Aviation · Hesston, KSBuilt 1976 · S/N 28-7690288 N761WWilliams Richard G J · Labelle, FLBuilt 1976 · S/N 60 N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195 N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320 N7620PSopwith James T · Sacramento, CABuilt 1961 · S/N 18-7737 N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321 N7621WAlexander Steven W · Kansas City, MOBuilt 1965 · S/N 28-2913 N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322 N7622PGriffin Robert L Jr · Washington, NCS/N 24-2833 N7622WBarnett Donald R · Atoka, TNBuilt 1964 · S/N 28-1586 N7623DBaker Donald A · Macedon, NYBuilt 1957 · S/N 22-5327 N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323 N7623HCowan Drew Paul · Anchorage, AKBuilt 1946 · S/N 12-498 N7623RAdamiak Jeffrey · Mount Laurel, NJS/N M-1246 N7623SKrejchik Daniel J · Portage, WIS/N 925-76 N7623WMidwest Heavy Construction LLC · Pleasant Hill, MOBuilt 1964 · S/N 28-1587 N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324 N7624SHovey Gregg Beecher · San Diego, CABuilt 1976 · S/N 207-76 N7624WHartley Douglas R · Florence, ALBuilt 1964 · S/N 28-1589 N7625FHarbaugh Steven J · Riverside, CAS/N 28-7725091 N7625SN4457s LLC · Southport, NCBuilt 1976 · S/N 330-76 N7625WWings Up LLC · Manteno, ILBuilt 1965 · S/N 28-2914 N7626FJamestown Jet Center Inc · Jamestown, NDBuilt 1976 · S/N 28-7715214 N7626LLester Androcles J · Ester, AKBuilt 1969 · S/N 399 N7626WStiles Kenneth R · Ozawkie, KSBuilt 1964 · S/N 28-1591 N7627FLo Co Holdings LLC · Loudon, TNS/N 28-7715215 N7627NRanger Aviation Inc · Burlington, COBuilt 1960 · S/N 18-7379

Back to AD 79-10-03 R2