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.

N7645FSagittarius Fox Aviation LLC · San Francisco, CABuilt 1976 · S/N 28-7790202 N7645WGold Rush Air LLC · Anchorage, AKBuilt 1964 · S/N 28-1620 N7646DBaier Warren R · Horicon, WIS/N 22-5355 N7646FShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 28-7790204 N7646GSky Aviation LLC · Encinitas, CABuilt 1970 · S/N 17259346 N7646PWebster Michael Sean · Hubert, NCBuilt 1961 · S/N 24-2860 N7647GIowa Lakes Community College · Estherville, IAS/N 17259347 N7647KLee Andrew · Anchorage, AKBuilt 1950 · S/N 20-468 N7647PEhni Scott Michael · Trinity, TXBuilt 1961 · S/N 24-2861 N7647WBeaulaurier Robert N · Walla Walla, WABuilt 1964 · S/N 28-1623 N7648RJohnson Jerome L · Victorville, CABuilt 1969 · S/N MB-457 N7649PBurton David P · Harviell, MOBuilt 1961 · S/N 24-2863 N7649WPatterson Cameron L · Stafford, VAS/N 28-1625 N764AAWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265624 N764BKFairmont State University · Fairmont, WVBuilt 1976 · S/N 17266891 N7650SMoore Aviation LLC · Westminster, COBuilt 1976 · S/N 928-76 N7651DLehrman Ronald L · Brownsburg, INBuilt 1957 · S/N 22-5360 N7651FAishvaryam LLC DBA · Lancaster, TXBuilt 1976 · S/N 28-7715224 N7651PShisler William · Phoenix, AZBuilt 1961 · S/N 24-2866 N7652FProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1976 · S/N 28-7715225 N7652WCarlson Justin Q · Sheridan, WYBuilt 1964 · S/N 28-1629 N7653FHyldburg Aviation Inc · Plymouth, MABuilt 1976 · S/N 28-7790205 N7653STow Plane Idaho LLC · Boise, IDBuilt 1976 · S/N 212-76 N7653WHernandez Kelvin · Wilkes Barre, PABuilt 1964 · S/N 28-1630 N76540Rifle Airshows LLC · Warrensburg, MOBuilt 1999 · S/N 80733 N7654DDouglas Michael G · Holt, MOBuilt 1957 · S/N 22-5364 N7654PCash Shawn R · East Randolph, VTFirst renewal noticeBuilt 1962 · S/N 24-2867 N7654RBeech C23 LLC · Galesburg, KSBuilt 1969 · S/N M-1285 N7655WRajh Cody · Chino, CABuilt 1964 · S/N 28-1633 N7656DBlackford Robert G · Summit Point, WVBuilt 1957 · S/N 22-5366 N7656KFrankle Joseph Wilder · Arlington, WABuilt 1950 · S/N 20-477 N7656PAnkney Gary L · Rector, PABuilt 1961 · S/N 24-2869 N7656RRobinson Lewis S · Irmo, SCBuilt 1969 · S/N M-1260 N7656WPchg Aviation LLC · Richmond, UTBuilt 1964 · S/N 28-1635 N7657WCrouse David E · Shrewsbury, MABuilt 1964 · S/N 28-1636 N7658SFlytwincos LLC · Las Vegas, NVBuilt 1976 · S/N 251-76 N7659DJones Emmett F III · Minden, LAS/N 22-5369 N7659FCharles City Aeronautics Inc DBA · Charles City, IAS/N 28-7715227 N7659PStyer David B · Pilot Rock, ORBuilt 1961 · S/N 24-2872 N7659RThomas Chris C · Mansfield, OHS/N M-1263 N7659WHutain Ronald P · Van Buren, ARBuilt 1964 · S/N 28-1619 N765ACAllen Steven J · Pewee Valley, KYBuilt 1999 · S/N 1269-99 N765FWManduca John M · Overgaard, AZBuilt 2020 · S/N P004 N765LBScott Jacob A · Paso Robles, CABuilt 1965 · S/N 282530 N765MARudy LLC · Middleton, WIBuilt 2003 · S/N 2221 N765RKays William G · Millersport, OHBuilt 2005 · S/N 209 N7660GKorn Clifton A · Hayward, WIBuilt 1970 · S/N 17259360 N7660PRegistered aircraftBuilt 1961 · S/N 24-2873 N7660RWare Joshua A · Inwood, WVBuilt 1969 · S/N M-1282 N7660WMelberg Bruce W · Weatherford, TXBuilt 1964 · S/N 28-1590

Back to AD 79-10-03 R2